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