Multiple .dbf File Import Help

N

nickg420

I have a situation where I need to import about 30 different .dbf files
all located in one directory, to a single table in Access.

I know this can be done elegantly with a combobox and and button usin
access forms but I just need a quick and dirty way of doing it withou
all that time. I was looking into the TransferSpreadsheet but one i
only does one at a time and I certainly hope there is a easier way tha
30 seperate TransferSpreadsheets. This is a one time needed thing whic
is why I don't want to spend the time to make it all pretty. An
suggestions on a quick fix will be appreciated.

Thanks,
N
 
A

Arvi Laanemets

Hi

One-time thing?
Open your dbf-files with Excel. Create a new excel file. Transfer all data
from dbf-files into a worksheet in created Excel workbook (copy - paste).
When finished, save the Excel workbook and then import it into Access.
 
N

nickg420

This isn't a one time thing this is something I will be using alot bu
at the same time isn't really important enough to do it elegantly so
just need some simple VBA to search the directory and import each fil
it finds one by one. They all have the same layout so it shouldn't b
to difficult. I working on a VB.Net solution now that may do the trick
but any ideas or suggestions would be greatly appreciated
 
Top