Importing Excel data into SQL existing table
Importing Excel data into SQL existing table
(OP)
Hi,
I am having a real hard time trying to import excel data into an existing SQL table, using SQL 2005. The wizard appears to only allow me to import into a new table, but that doesn't make much sense. Can anyone help me with this?
I am having a real hard time trying to import excel data into an existing SQL table, using SQL 2005. The wizard appears to only allow me to import into a new table, but that doesn't make much sense. Can anyone help me with this?





RE: Importing Excel data into SQL existing table
to append use
insert into <table> select * from EXCELINK...[<your sheet>]