Importing Data

[BazLondon]

Hi
I'm trying to import data from an Excel spreadsheet into an empty table using the Import Wizard (File/Get External Data/Import). All's well until I'm presented with the window that tells me that I can "store" my data either in a new or existing table. However the radio button and Existing Table name field is grayed out. Any ideas gratefully received.
Baz

 

[stephen81]

Do you have any existing tables? If not, maybe that's why the existing table option is greyed out?

 

[BazLondon]

Hi Stephen
Thanks for prompt reply
Yes, I do have existing tables (and an existing database). I cleared the table I wished to populate of all data prior to the import attempt and I've even re-tried the import having moved the Excel spreadsheet into the dame directory as the database but still with no success.
I can't help wondering if it's a bug in ACCESS.
I've got round the problem by importing into a new table and then running an Append Query to populate the original table - a bit of a pain but at least it achieved the desired result

 

[stephen81]

What version of access are you using?

 

[The_Doc_Man]

By any chance, had you done this before and had you saved the import specification? If a table was specified in the import spec and that table no longer exists, you MIGHT have seen what you described.

Were the tables external to the DB and linked? That might confuse the import wizard maybe a little bit.