 Excel to SQL DTS, no longer working -
07-06-2004
, 10:46 PM
I have a DTS package setup to import from excel to SQL. With the original Excel file, it works great. However with my new Excel document, I cannot get it to work. It seams to be a format thing but they are setup identicle. I've tried everything, even copying and pasting 1 row into the old excel document, exporting as plain text and re-importing and everythign else I can think of.
When I copy and paste the fields from the old excel file to the new one, those fileds work. They are all set to type 'general' in excel. Is there some sort of advanced field type feature I'm missing ?? It is always the number fields that it is not getting. I have the follow statement in my SQL and it doesn't work with the new file.
[HOS$].[Month] + '/2/' + [HOS$].[Year] AS SaleDate
Please help.
|
Linear Mode
