Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

asked on

Specify file path in import text ACCESS 2003

I have an import that I am creating in my development version of the database.  the source for the text file is in my development environemnt, but the path will change i production.  I am a little perplexed in how to I tell the code to pick up the path in the transfer text statement?  The saved import seems to only use the original location and specification has to be added manually, I want to use the specification, but pass in the path string so I can change the variable when it goes online.

Sandra
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

How are you doing the import now? Can you show the code you're using?
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandra Smith

ASKER

Thank you, it wasd the path placement and your are right, the difference between Import Specificiations and Saved Imports had been a bit perplxed, but I got it now.  

Sandra