Linking Acess with Excel

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

Guest

I am trying to link an Excel spreadsheet with a Access Database so that, when
I enter data into the Database, it automatically places that data into the
spreadsheet, which would do all the calculations for me [there is a reason
why I need the table, courseworks minimum requirements are 3 tables.] Is it
possible to do this and not make the database read-only?
 
Hi

Open Access database. Go to File – Get External Data – Link Table and
browse for the spreadsheet after selecting Microsoft Excel from the dropdown
arrow in the File of Type box: The spreadsheet and database must be in the
same style and order column wise. Try it.

Regards,

Jaleel
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Changing Database links? 3
Link Excel to Access 3
I want to link a word document to a excel spreadsheet...how? 2
Record-Locking remains open after closing 0
"Calculating Cells" Mystery 2
Wrong Teaching of Excel 6
convert text to sentence case 4

Back
Top