Weird Import Request

[The Pig]

Guys,

Got a bunch of DBF files all named pikcup.dbf. They are all stored
under a directory named c:\reports but are all under multiple sub
directories. I need Access to import all pickup.dbf files into a
single table. I have no idea where to start. Any ideas.

The Pig

[Bob Quintal]

ia*******@yahoo.com (The Pig) wrote in
news:81**************************@posting.google.c om:

Guys,

Got a bunch of DBF files all named pikcup.dbf. They are all
stored under a directory named c:\reports but are all under
multiple sub directories. I need Access to import all
pickup.dbf files into a single table. I have no idea where to
start. Any ideas.

The Pig

Start with a course in Visual Basic programming. :)

You'll need a do loop that uses the DIR command to get the name of
each subdirectory, add the pickup.dbf filename, use the fullpath
and name to link via ODBC and append the data to your Access
table, unlink the table, and repeat until done.

Bob Q

[mgoodrum]

I long time ago I wrote a simple VB program to recurse through
directories and write the path and file name of every sub directory
and file in a specified folder to a MS Access db table. That list is
the first step that you need in getting MS Access to import the .dbf
files. The second step is writting the code in MS Access to import
the .dbf files from the list and import into a MS Access Table.

If your are not familar with VB. There is a sample program included
with VB called picture viewer. This program gives you the basic
structure of the import tool. You just need to add some loop
structure, and write the results to a txt file, that you can import
into MS Access.

Hope this helps
ia*******@yahoo.com (The Pig) wrote in message news:<81**************************@posting.google. com>...

Guys,

Got a bunch of DBF files all named pikcup.dbf. They are all stored
under a directory named c:\reports but are all under multiple sub
directories. I need Access to import all pickup.dbf files into a
single table. I have no idea where to start. Any ideas.

The Pig