path entry for users

[cgshunter]

I'm trying to create a macro that will prompt a user for the path of a file he/she is attempting to import because there will be multiple users with files in different places using the database. Any suggestions?

 

[yellow]

Not sure if you can, easier to write it in code, at it's most basic level:

Dim sFileLocation as string

sFileLocation = InputBox("Enter File Location:")
DoCmd.TransferText acImportDelim, "Spec Name", "Table Name", sFileLocation

The transfertext line would depend on what you were trying to import. If you are unsure write a macro and then save it as a module and cut and paste the code, altering the sFilelocation part.

Hope this helps.

 

[cgshunter]

Macro

Works like a charm - Thanks a Gig. You're officially promoted to hero status.