Importing Data from Excel

Hi,

In SQL 2005, is there a way to autmotatically import data from excel into an existing table. So far, I can only do this into a new table. Any help is appreciated.

Well,

I am not an expert on this one, but I have had to play with Excel sources/destinations for the last few weeks, and I am pretty sure that the destination editor on your OLE or SQL Server destination should include a drop down box that will populate with your table names from the database that your connection manager is pointing towards.

The 'new' button that is there is just for creating a new table in the selected database at that moment.So, once you use the new table functionality, the destination is using an existing table (being the one you created) each time the package is executed.

I hope this was what you were looking for, but if not, maybe I misunderstood the question. Anyway, like I said, I hope this helps.

|||

MarkWest05 wrote:

Hi,

In SQL 2005, is there a way to autmotatically import data from excel into an existing table. So far, I can only do this into a new table. Any help is appreciated.

Are you using SSIS? With SSIS you should be able to do it with no problem; just by following the direction in Clint Edwards
post.

|||

And if you are using the Import/Export wizard you should be able to select destination table to copy data to. On the Select Tables page, click on the destination table cell and choose an existing table from the drop-down list or simply type the name of the existing table.

HTH.

|||If you are importing anything more complex than a flat set of data, Data Defractor is a SSIS Excel source component which makes life quite simple in terms of importing complex data from Excel using SSIS.

Without this sounding like an advertisement, it allows you to specify areas within a spreadsheet you want to import and how you want to deal with them.

See www.DataDefractor.com for more info.