Import data from Excel

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

Guest

Hi,

I have an access DB listing all clients info on form records.. I want to
call up that clients account information from within their record via a
command button from a worksheet within an excel workbook.

Any ideas?
 
I'm not quite sure what you are trying to do because your subject states you
are trying to Import from Excel, while the body seems to indicate that you
are trying to Import into Excel from Access.

If you want your import to be carried out from within Excel, try asking in
an Excel newsgroup about creating the structure yo do that. You might also
try:

http://www.mvps.org/access/modules/mdl0035.htm

If you want to import the data into Access, there are several ways. You can
use TransferSpreadsheet Action in a macro, or method from code, or you can
establish an automation connection. The help files should be able to give
you the info on TransferSpreadsheet. Have a look at the following for Excel
automation:

http://www.mvps.org/access/modules/mdl0006.htm

http://www.mvps.org/access/general/gen0008.htm
 
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

Access Automatically Send a notification email once a record is added 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Tools to import complex Excel spreadsheets into ACCESS 6
Excel 2003 Form-Import data in designated cells 3
Access 07: How to pull in information 4
Problem with Items Selected from List Box 2
Excel Data Transfer Issue (strange situation) 1
Importing a file - with timestamp (datestamp) within the imported 5

Back
Top