import external data from changing file name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to set up an external data link to import data from a text file
into excel. The problem is that I need the link to look for a new file name
each day. So, each day I need to import the data from the new file to the
same location in Excel. The names of the text files will always follow a
particular standard based on the current date (i.e. DATABASECCYYMMDD.TXT).

How can I have the link always import data from the text file with the
current date in its name?

Thank you,
Nathan
 
If your text file is automatically generated by a scheduled export from a
database, (in my case, overnight processing of GL, etc) I have the IT group
generate 2 text files. One with the date stamp to retain history and a
second with a Non-Changing file name, like: GLDOWNLOAD.TXT (overwriting the
file if necessary). That way, no special programming is necessary and links
always pull from the same filename.

Would that work in your situation?

Regards,
Ron
 
That is definitely a solution. The problem is the txt file is created via
some vendor's software and not sure if it can be set up to write the files
like this. I will check it out. Thanks.

Nathan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Import 4 Different Excel Files from One Folder 0
Import external data 6
Excel Import External Data by Date Automatically 0
Easy Steps to Import PST Files to Office 365 0
Import external data link disappears 1
Import External Data by Date 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top