Macro for Importing

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Hi,

I get a report of accounts each day that I would like to
import to my DB through a macro, but I need it to show a
popup asking me to locate the file to put it in. So
basically, it needs to:

1. Create a new table for todays data
2. Pop up: "Which file would you like to import?"
3. User selects file
4. Macro copies it to table, with same columns
5. Macro names the table the filename date.

I know this is probably pretty basic, just not sure how to
do it and I'm on a time crunch. Thanks for the help...
 
Kate,
First, I fear that what you want to do is way beyond the capability of a
macro. You'll need to create a form with a textbox where you fill in the
file name and and a button on the form that runs your import. Second, Rather
than creating a new table for each day's data, you might want to consider
merely appending the data to one table with a date column that defaults to
today's date. Then you can always pull the data for any given date with a
query.
 
Back
Top