By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Weird Import Request

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.