Automation from Flat Text File to Access Database

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Here is my situation. I have flat text files which appear
to be excel files, but which only contain the .xls
extension and no properties inherent to true excel files.
I need to automate the importation of those files into an
pre-existing access database. I wrote a batch file to
automatically "move" the data.xls to data.txt files. My
question is how can I use a macro or vb code to execute
that batch file, then automatically import all of the
newly created text files (probably around 15 files) into
access. Any help would be greatly appreciated.
 
-----Original Message-----
Here is my situation. I have flat text files which...
I need to automate the importation of those files into an
pre-existing access database. I wrote a batch file to
automatically "move" the data.xls to data.txt files. My
question is how can I use a macro or vb code to execute
that batch file, then automatically import all of the
newly created text files (probably around 15 files) into
access. Any help would be greatly appreciated.
.
Click to expand...
Hi Bob,
create import specifications using file, get external
data, import. change the file type to txt. The import
wizard is then displayed. Complete each step up to the
last step. Click Advanced. Then click Save to save the
specification with a descriptive name (note the name for
the next step in this process). Finally click finish.
Check that there are no import errors (if 'yes', fix so
that you can rely on your specification).

then use docmd.TransferText method to import. to use
online help, type this method into a module and then, with
the cursor on the text, press F1 key.

Luck
Jonathan
 
Thank You

-----Original Message-----

Hi Bob,
create import specifications using file, get external
data, import. change the file type to txt. The import
wizard is then displayed. Complete each step up to the
last step. Click Advanced. Then click Save to save the
specification with a descriptive name (note the name for
the next step in this process). Finally click finish.
Check that there are no import errors (if 'yes', fix so
that you can rely on your specification).

then use docmd.TransferText method to import. to use
online help, type this method into a module and then, with
the cursor on the text, press F1 key.

Luck
Jonathan
.
Click to expand...
 
Back
Top