Import a file using a field on a form

Taz

Guest

Posts: n/a

6th Apr 2010

I am using Access 2003. I created a form for a user to enter the path and
filename for import. I then added a button that runs a macro to transfer the
text file. In the file name in the macro I have
forms!frmImportData!filename. It is not working. Is it possible to import a
file this way, and if so how do I do it? The filename will change each time
it is imported (a monthly run). I really don't want the user to have to open
the macro and key in the new filename each time. I'm trying to make it as
seamless as possible. TIA.

« synchronize network shared file saved by 2 multiple users | How can I name an imported excel spreadsheet »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Excel File into Access DB where user can specify file name andcell range to import	ssa	Microsoft Access External Data	1	18th May 2011 01:18 AM
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported.	M Skabialka	Microsoft Access	0	13th Jan 2009 06:32 PM
Automate .txt File import and assign Import ID field with filename	=?Utf-8?B?RUE=?=	Microsoft Access External Data	1	1st Jun 2006 06:30 PM
Import an Excel File into Existing Table not using the Import Wiza	=?Utf-8?B?TG91aXNl?=	Microsoft Access VBA Modules	1	2nd Mar 2006 11:01 PM
Linking a Field of a Form to a Field of a Sub Form on another form	FA	Microsoft Access Forms	2	24th Nov 2005 09:20 AM