PC Review


Reply
Thread Tools Rate Thread

Bulk Import DBF files to access 2003

 
 
Taxi Aileen
Guest
Posts: n/a
 
      13th Aug 2010
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

 
Reply With Quote
 
 
 
 
R & A Turner
Guest
Posts: n/a
 
      15th Aug 2010
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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:58 AM.