Importing data from excel to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi i am working with office 2000 and need to import data from Excel into
Access 2000 can anyone tell me how to do this
 
Manually, you do it using File | Get External Data | Import from the menu.

Through code, you're best off using the TransferSpreadsheet method.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing from excel 2
Excel Data Transfer Issue (strange situation) 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Easy Steps to Import PST Files to Office 365 0
Import data from Access to Excel containing VB code 3
Importing Excel Spreadsheet into Access 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Browse button for access form 1

Back
Top