automate importing multiple files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import several hundred text files and several hundred excel files
into an Access database. How can I write a VBA program to import one file
after another, perhaps as part of Do Loop or If..Then..Else procedure?
Thanks.
 
Yes, you can.

Something like the following will find all the .txt files in a given folder
and let you process them one at a time:

Dim strFile As String
Dim strFolder As String

strFolder = "C:\MyFolder\MySubfolder\" ' the final slash is important!
strFile = Dir$(strFolder & "*.txt")
Do While Len(strFile) > 0

' put your code here to use the TransferText method
' The full path to the file will be strFolder & strFile

strFile = Dir$()
Loop
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import 4 Different Excel Files from One Folder 0
import completed forms into access 5
Parse and rename multiple .pdf files 4
Automate Multiple import .txt 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Text Files Into Access 1
How do I import an Excel file with MULTIPLE WORKSHEETS into Access 8
Automating Importing of CSV Files with dynamic feilds 4

Back
Top