I'm using DTS(Data Transformation Services) to import an excel file to SQL 7. My problem is that DTS throws an error on numbers and dates unless the field in the SQL table is VarChar. It will not put a number into a number or a date into a date because everthing in Excel is viewed as a string. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
