Importing Data from an Excel File Doesn't Work

[Phoenix22]

Hi,

I'm using DTS in Enterprise Manager to import data from an Excel file to a table. When I preview the data I'm importing, the data range is correct. However, when I finish importing, my table is empty. After the actual importing, I get one notification that says the data and table were copied successfully; however, my table is empty. Does anyone know how this problem can be resolved?

Thank you for your time and help.

 

[rasETL]

Are you sure the package is not loading a Table.

Sometimes, the package is pointing to a different Server
or maybe a different Database.

Check to see if the Table may be somewhere else.

As an alternative, you could save the Excel Spreadsheet as a comma-delimited file, and try loading a text file rather than a spreadsheet.

Hope that helps.

 

[gradley]

If you are truely importing from an Excel spreadsheet and not a comma delimited file, you need to specify the worksheet you are importing from.

Is it possible you are pointing to a worksheet that is empty and not the one you are expecting? Also, if it is copying records, you should see a record count during import.