Bulk Import DBF files to access 2003

's Computer Specifications

Also posted in comp.database,
I have hundreds of dbf files to import from a folder to a table in access
2003
and or 2007. At present I import each file as a table then copy and paste
to a
master table. For other imports (text, excel etc) I have a macro to import
all
files in a folder, but I have no option to import DBF files, Anyone able to
advise?.
TIA
taxi data

's Computer Specifications

Answered in comp.databse... thanks

"Taxi Aileen" <(E-Mail Removed)> wrote in message
news:4c659a5e$(E-Mail Removed)...
> Also posted in comp.database,
> I have hundreds of dbf files to import from a folder to a table in access
> 2003
> and or 2007. At present I import each file as a table then copy and paste
> to a
> master table. For other imports (text, excel etc) I have a macro to import
> all
> files in a folder, but I have no option to import DBF files, Anyone able
> to
> advise?.
> TIA
> taxi data

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2003: Import Extensionless Files	Brig Siton	Microsoft Access	3	25th Mar 2010 07:04 PM
help to bulk import and append - newbie, Access 2007	=?Utf-8?B?TWFyaWFuIE0u?=	Microsoft Access Macros	6	28th Aug 2007 08:50 PM
import text files into access 2003	=?Utf-8?B?Z2Vlaw==?=	Microsoft Access External Data	0	28th Aug 2006 06:30 AM
unable to import .xls files into access 2003.	=?Utf-8?B?SmF5?=	Microsoft Access External Data	1	28th Jan 2006 01:56 PM
Can I import Access fields into Outlook recipients for a bulk emai	=?Utf-8?B?U2FyYWg=?=	Microsoft Outlook Discussion	1	4th May 2005 02:25 PM