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
Bookmarks