Import from an excel sheet

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

Guest

How could I have a control on a form that would import data from an excel
sheet and add records to the table represented by this form in access 2007?
and how to have a control for export as well to an excel sheet?

i need help ASAP.
 
for got to say something, I dont want to import using the get external data,
i need to put a button on the form to do this!!
 
Look at the TransferSpreadsheet method. It does programatically what Get
External Data does manually.
 

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

Using TransferSpreadsheet Macro to import a single sheet from exce 1
Help with Importing from Excel into Access 0
Importing from Excel row order 5
Importing from Excel to a droplist field 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import from Excel 2003 to Access 2003 4
Excel sheet in Access Form 2
export and open an excel file from access 2

Back
Top