How do I import several text files into excel or access ?

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

Guest

I receive hundreds of text files daily that i have to convert to excel. How
can I automate the process so that i dont have to manually open every text
file one at a time?
 
Assuming the text files are always the same name and always in the same
place, you won't have to write any code. Just go to Tools...Macro...Record
New Macro, then go through your process, then stop recording.
 
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
Which is the best MBOX Converter Tool different formats conversion? 5
Importing Long Numbers as Text cells 1
How can we convert OST to PDF file format? 1
Import 4 Different Excel Files from One Folder 0
How can I migrate MBOX to PST? 2
importing text file to excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top