Import Multiple tables into Access | File Dialog VBA

[SeaAnne]

Hei :)

I'm fresh in Access. I'm creating a form whose first step is to import 3 files from Excel into existing tables.I want to ask the user the file path of each file and then import them to 3 separate tables.

Do you have any suggestion?

I really appreciate your help :)

[lillyehrhart]

click on your import, if you already have the tables created that you want to move the files into, then just select that table that you want to append to each time. If you do not have the tables already created, then just add them to your database. do you want to do that in your form or just do it straight from access?

[lillyehrhart]

you could try something like this. i used this example, just change up the path and rename things and it should work, after you create your button for import

Private Sub buttonimport_Click()
txtFilePath = ITC_FileDialog("G:\PD\SPRDOCS\Classification Project\SPR Class Database\inbound")
 
Dim s() As String
s = Split(txtFilePath, "\")
SprFileName = (s(UBound(s)))
'SprFileName = s.Length - 1
 
 
 
End Sub