Insert All Records From Worksheet To Access Table

Hi All,

using Excel/Access 2007

In code below, I would like to INSERT all records from worksheet "tmpf" to a table in Access
I copied the header row from the worksheet to a new worksheet
I imported the new worksheet to Access to create a new table to make sure headers are exactly the same
I verified all string variables I am passing from the worksheet
I verified that I selelcted the correct file in the GetOpenFilename method.
I receive no error messages
I checked the temporary workbook and worksheets - all data is as expected
The worksheet I am trying to INSERT from has 10 Fields, 1 Header row, and 467,696 records

When all is complete I check the target table in Access - nothing.
Any ideas what else I can check as to why this process is not working?

thx
w

Please Login or Register  to view this content.

Genius,

I forgot the ADO Connection execute command after the SQL String

Please Login or Register  to view this content.

Thanks for letting me use the forum as a sounding board
Full revised code below
Works great!

thx
w

Please Login or Register  to view this content.