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...
Galaxiom,
I'm gong to give DOS a try after using For /F to skip the header lines. Now I have strugled on the following issue.
I have several the .txt file with some account info. First, I need to send info in one .txt file to deferent files, then parse lines with code to save info to...
Thanks you very much for your time. This is exactly what I need. The book I have, Access 2007 Inside Out, doesn't talk about DOS command and Shell command. Do you have recommendation on the book that I can read?
Again, this is exactly what I need. Thank you very very much.
That is great! I'll look into it. Thanks.
Queation: Can I combine FOR /F command with VBA? My project is to create a sub to read several text files to tables. I need to run this sub every month.
Very appreciate you time.
Thanks for your reply.
What I'm going to do is to create a produre to read the text files (I have several).
Can you tell me how to attach/post the text file here?
Thanks again
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
Thanks for all your responses.
Should I be able to create table at SQL view instead of query disign view with the following code?
create table Contract (
C_Name text(50) primary key not null
)
The msg popped up: The query must have at least one destination field
Thank you very much
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...