I'm working on a Sub to automate importing data from Excel to Access (table) and keeping getting an error msg:
Run-time error 3170. Could not find installables ISAM.
MS Access 2007, MS Office 12.0 Object Library is selected.
Any help will be appreciated
'Import files to the new tables...
I have a text file which has a header with several lines. Is there any to skip the lines, then read the rest of the file to a table? I have a sample file but don't know how to attached it.
Thank you in advance
I'm using Access 2007. In SQL view, I'm not able to create tables. But I can do select query in SQL view.
Do I need to set up something in order to create table in SQL view?
Thanks a lot
I have several questions about recordset.
1. create a recordset field's name:
With rstA.Fields
.Append "fName", adChar 'got error.
End With
2. After is is created, I will populate it by following, is it correct?
With rstA
.AddNew...