Automating Importing files?

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.
 
M

Magius96

What kind of file is it being imported from? Is it a textfile? Is it an
Excel Spreadsheet? Is it a CSV file?
 
B

BeckyC

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?
 

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

Top