Import code

[AFKAFB]

Hi
I need to write some code that will allow the user to browse through any path/folders/files, select the file and then import the file into the database.
In total the user will be selecting up to ten different files - excel/text etc.
thanks
afkafb

 

[Remou]

Hi
Have you seen:
IMPORT Excel Sheet into Access allowing user to select file
thread705-760625

 

[AFKAFB]

hi
apologies - whern the user clivks the button it needs to open the Import screen allowing the user to select the file they want per the spec saved. The Transfertext command is fine but the path/file name could change and i need ot give the user flexibility.

 

[Remou]

I am afraid I still do not quite understand, I guess you don't mean:
DoCmd.RunCommand acCmdImport
Do you mean something like:
How to allow user to select file
thread705-1148501