Access

[Nancy]

Does anyone know how to successfully export a table from
Excel into Access? I sure would appreciate some feed back
to accomplish this.

Thanks Nancy

 

[Randy Wayne]

It is actually much easier the other way around - import
your Excel spreadsheet into an Access table.

Open your database.
Select File menu
Select Get External Data -- Import
Follow the wizard

Let me know if this helps

 

[Margo]

-----Original Message-----
Does anyone know how to successfully export a table from
Excel into Access? I sure would appreciate some feed back
to accomplish this.

Thanks Nancy
.

I suggest you Go into Access, File, Get External Data,
Import Data, File type Excel - be sure your spreadsheet
has data ready for the Access table - Access Wizard guides
you to completion

 

[Nancy]

Thank you for your help!!

-----Original Message-----

I suggest you Go into Access, File, Get External Data,
Import Data, File type Excel - be sure your spreadsheet
has data ready for the Access table - Access Wizard guides
you to completion
.