Just to clarify: I'm not necessarily asking for an answer, but I obviously don't seem to have any idea where to start, so a nudge in the right direction -- web-site, keywords, etc. would be greatly appreciated. :)
Isaac Original Message ----------------------- I realize this is off-topic, but I've been searching for a while to try and find some information and ... likely I don't know where to search or what words to use, but I thought someone here might have some idea. I'm importing data from a DBase5 formatted .dbf file into a table in SQL Server 2000 using DTS. It all seems to work fine except that I noticed one column in particular is supposed to be a varchar(35) column is only varchar(10) even though the data going into the dbf was longer... As I understand it test data going in was in the form "[EMAIL PROTECTED]" and coming out is in the form "[EMAIL PROTECTED]" ... I tried to examine the dbf file using notepad (I never saved it in notepad, so I don't think it should have changed the file structure) and don't see either of those forms... Instead what I see is the form "[EMAIL PROTECTED]". So I'm really confused. I'm not sure if the issue is in my DTS package or if it's in the population of the dbf (which I'm told was converted from an excel spreadsheet, although I don't know anything about how that was done). Man I hate working like this. Thanks in advance, Isaac ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
