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.
>.
>
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-----
>
>>-----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.
>>.
>>
>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
>.
>