ADO INSERT INTO with Excel table

[litrelord]

Hi,

I'm writing some code to use ADO to pull some data from access. Everything works fine but I want the data to be placed in an existing table and using CopyFromRecordset seems to wipe the table. I can use an ODBC query, change the command and refresh but I'm trying to learn more about ADO at the moment.

Is there a way to use INSERT INTO on an excel table using the SQL command in ADO?

Thanks

Nick

 

[Fazza]

Hi, Nick. Yes there is. I'm guessing that providing a few links will be a good way to help. google will find more. regards, Fazza

http://www.xtremevbtalk.com/showthread.php?t=217783

http://excelkb.com/

http://msdn.microsoft.com/en-us/library/ms678086(VS.85).aspx

http://support.microsoft.com/kb/257819

http://www.excelkb.com/article.aspx?id=10008

 

[litrelord]

Thanks Fazza, looks promising. Had tried a google search but could only find information on using INSERT INTO to add rows from excel to access. Obviously using the wrong search words!

Cheers

Nick