Automate importing data using input from user?

[LauraJM]

I need to import data from FoxPro into Access, but each time I will want it to look at a different file. I want to be able to do it seperately, so I can't loop round the files.

Is there anyway to get the value of cfile(see below) from the user and that is where Access will look for the data???

Private Sub Command1_Click()
Rem Importing Foxpro data
Rem ASK USER FOR cfile value

cfile=????????

DoCmd.TransferDatabase acImport, "Microsoft FoxPro",
"C:\Transfer\data\cfile\area.mdb, acTable, "AREA"
End Sub

I would be grateful for any help.

 

[vb5prgrmr]

See if you have the Microsoft Common Dialog Control and if so you could use the showopen method.

Good Luck