Import from Excel

[John Hewitt]

A 'newbie' question - importing into Access from Excel. Googled the
group postings but I can't find the amswer

I have a 50 line three column file in Excel that contains Names and
Tel numbers. Each column is named to agree with the Access database.

Read the instructions "Import Excel files into an Access database".
Followed them to the letter. Everything goes well until the final
Wizard action is clicked "Import to table 'PHONEDIR'.

But then I can't get past a message that says " Table 'PHONEDIR' is
already open. Well sure it is, the import instructions told me to open
it? There's no other program holding it open - checked with Task
Manager.

I am missing something obvious here - sure could use some advice,
please ??

John Hewitt Malaga Spain

[PC Datasheet]

John,

Try this:
1. Open your database to the database window - tables
2. On the toolbar at the top of the screen, click on File - Get External
Data - Link
3. Navigate to your Excel file and select it
4. Click OK and follow directions
5. Create an append query based on your linked table and append the Excel
table records to the database table of your choice.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John Hewitt" <ri***********@arrakis.es> wrote in message
news:1095969870.ro69V0+dR+zLdu6mHgUM0g@teranews...

A 'newbie' question - importing into Access from Excel. Googled the
group postings but I can't find the amswer

I have a 50 line three column file in Excel that contains Names and
Tel numbers. Each column is named to agree with the Access database.

Read the instructions "Import Excel files into an Access database".
Followed them to the letter. Everything goes well until the final
Wizard action is clicked "Import to table 'PHONEDIR'.

But then I can't get past a message that says " Table 'PHONEDIR' is
already open. Well sure it is, the import instructions told me to open
it? There's no other program holding it open - checked with Task
Manager.

I am missing something obvious here - sure could use some advice,
please ??

John Hewitt Malaga Spain