Automating Importing files?

  • Thread starter Thread starter BeckyC
  • Start date Start date
B

BeckyC

Is there a way, maybe using vba code, to pull in the saved imports from a
table creation? I create a table and save the import steps and then need to
reimport this file later in a macro. I need to do this with about 90 tables,
so I want to automate it. Any suggestions on how? We don't run Outlook at
this point, so I can't schedule it to run. I want the macro to kick it off.
 
What kind of file is it being imported from? Is it a textfile? Is it an
Excel Spreadsheet? Is it a CSV file?
 
They are excel spreadsheets and 1 csv file

Magius96 said:
What kind of file is it being imported from? Is it a textfile? Is it an
Excel Spreadsheet? Is it a CSV file?
 
Back
Top