Importing data from excel into access

J

Jackie

Hi!

Is there anyway to import or copy data from excel
spreadsheets into access?

Thanks!
 
D

David

-----Original Message-----
Hi!

Is there anyway to import or copy data from excel
spreadsheets into access?

Thanks!
.
There are a number of ways. A quick way is in the
Click to expand...
control source of a text box enter =dde
("excel","sheet1","r1c1") r1c1 is row 1 column 1
 
S

SueM

Yes, in access click file, then get external data, then
change the file type to excel and select your file and
follow the prompts.

You can also do it using vb with the TransferSpreadsheet
action.
 

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

Need Help with Macro Security 1
Integrating information from Word to Excel (not mail merge) 1
Booklet in Word, Merge Directory from Excel 0
Linking data in MS Word into Excel 5
How to automate update on weekly reports spreadsheet 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Need Help with a VBA subroutine 0

Top