Is it possible to automate the importing of exporting text data?

  • Thread starter Thread starter MonitorOntario
  • Start date Start date
M

MonitorOntario

Is it possible to automate the importing of exporting text data? I hav
huge files of text data that I wish to import into Excel. The task o
setting columns and declining certain columns of data is daunting an
is repeated from file to file.
I'd like to save time by automating the process from file to file
rather than doing the same tasks for each
 
MonitorOntario said:
Is it possible to automate the importing of exporting text data? I have
huge files of text data that I wish to import into Excel. The task of
setting columns and declining certain columns of data is daunting and
is repeated from file to file.
I'd like to save time by automating the process from file to file,
rather than doing the same tasks for each.
Click to expand...

You'd need to use VBA, but the bulk of the coding could be done by the Macro
Recorder. Turn on macro recording *just* *before* the next time you specify
how to import these files.
 

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

Import and Export Text data 2
Importing Text Files Into Access 1
Importing Text 3
Importing Long Numbers as Text cells 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import data from one file to another 1
Cell not calculating after importing data 2
Import & Export 1

Back
Top