DTS Export fails on bad date

  • Thread starter Thread starter Dean Slindee
  • Start date Start date
D

Dean Slindee

While trying to import an excel spreadsheet to a SQL Server table, DTS
fails, pointing to a column with date values. I have looked at all the date
values, and they appear correct. I need to get this excel spreadsheet
loaded to a database table. Is there any way to pinpoint the exact cell
causing the problem? Or, can you think of another way to export the data in
the spreadsheet besides DTS that might not be so sensitive to data content?

Thanks,
Dean Slindee
 
I suggest you try doing a bit of analysis of the datatype of the date column by taking a random sample of the data. If the data you are to import isnt enormous, then you could try scanning for incompatibilities in the date field. Make sure the datatype of the date fields in Excel matches that of the corresponding field in sql server i.e. date type to date type or if stored as string, then both fields must be of string type in both Excel and Sql server.If this fails, then try importing the data into a Ms Access Database and then perform DTS from the Access database to the Sql server database.
I hope this helps
Best of luck
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
DTS WIZARD alternatives? 0
date format in excel imported from an SQL DB. 2
Running MS Query on an Excel Spreadsheet 3
Export Pivot table 1
Data exported to excel 2007 changes cell number format to 'general' ? 1
Accessing Data in an Open Excel Spreadsheet 2
PERFORM ACTION ON HITTING ENTER 1

Back
Top