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
