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