RE: Displaying data from XLS file

[Dan G. Switzer, II]

John,

I have a datasource created with XLS as below:

SELECT *
FROM [HRJobPostings$]
IN 'd:\\Inetpub\wwwroot\HRJobPostings\HRJobPostings.xls' 'EXCEL 5.0;'

In a row for the column, Additional, it has:

Experience should also include: configuring and monitoring of Cisco
switches, routers, wireless, firewalls, VPN, and IDS; maintaining
network security; developing and maintaining documentation related to
the network; developing and managing organization-wide software
deployment; being on call in support of a 24 x 7 organization.

but when it is being displayed, it ONLY shows:

Experience should also include: configuring and monitoring of Cisco
switches, routers, wireless, firewalls, VPN, and IDS; maintaining
network security; developing and maintaining documentation related to
the network; developing and managing organization-w

Why is ide software deployment; being on call in support of a 24 x 7
organization. not showing up?  This means only 255 characters are
showing up.

First, I'd recommend not using Excel as a datasource name, unless it's for
very temporary low traffic processes.

It looks like Excel is cropping the text to 255 characters--which means it's
probably treating the field as a varchar(255).

Here's a link that talks a bit about using Excel as a datasource:
http://www.idude.net/excel/articles/using_excel_file_datasources.asp

I'd recommend either using something like DTS (if you're using MS SQL
Server) to import the spreadsheet into a table, or use something like the
jExcelApi (a Java API for interacting w/Excel files) to read the data in.

-Dan  



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227397
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Displaying data from XLS file

[John Lucania]

I have a datasource created with XLS as below:

SELECT *
FROM [HRJobPostings$]
IN 'd:\\Inetpub\wwwroot\HRJobPostings\HRJobPostings.xls' 'EXCEL 5.0;'

In a row for the column, Additional, it has:

Experience should also include: configuring and monitoring of Cisco
switches, routers, wireless, firewalls, VPN, and IDS; maintaining
network security; developing and maintaining documentation related to
the network; developing and managing organization-wide software
deployment; being on call in support of a 24 x 7 organization.

but when it is being displayed, it ONLY shows:

Experience should also include: configuring and monitoring of Cisco
switches, routers, wireless, firewalls, VPN, and IDS; maintaining
network security; developing and maintaining documentation related to
the network; developing and managing organization-w

Why is ide software deployment; being on call in support of a 24 x 7
organization. not showing up?  This means only 255 characters are
showing up.

I thought that it is the limitation with 'EXCEL 5.0;', but with this:

SELECT *
FROM [HRJobPostings$]
IN 'd:\\Inetpub\wwwroot\HRJobPostings\HRJobPostings.xls' 'EXCEL 8.0;'

I am getting the same result.

How do you resolve this?

jl

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227389
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54