Saved Import in Query

[Kimbertha]

Hello Everyone:



I have a database that uses a number of Saved Imports to bring in data from CSV files. Many of the fields have formatting that I set-up with the "advanced" tab in the Import Wizard. They were a pain to set-up, but now that they all set, it's great. Except for one thing . . .

After I set-up the imports, I needed to change the names of the destination tables. It's not important why I had to do this. For example, Import1 imports data to a table named Activity. But I later had to change the table name to EmpActivity, and all of my subsequent queries using EmpActivity.

So now I must refresh my database with new data, but my tables are all coming in with the old names. Of course I can manually change them to the new names. But is there a way to edit the destination table names in the Saved Imports to change them from, for example, Activity to EmpActivity.

Note that I am not talking about editing the name, description, and path of the Saved Imports. I've played around with those and they don't affect the name of the destination table.

Seems weird that Access 2007 doesn't give you a way to do this. Any ideas?

Regards,

Kim

[weekend00]

Create one query for each table, e.g.
Query: EmpActivity
select * from Activity