Linking Worksheet to Database?

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

I know how to link an Access Database to a Spreadsheet, but how do you do the
reverse?

Thank you
 
In Access choose File, Get External Data, Link.

To make this work properly I suggest you range name your data set in Excel.
 
That works if the data was in Excel and I want to create a new table in the
database. But my data is already in a table in the database. So I want to do
the opposite.
 
Well in that case, choose Data, Import External Data, New Database Query, and
find and select your database. Then proceed through the wizard.
 
Ah, that did the trick. Thank you

Shane Devenshire said:
Well in that case, choose Data, Import External Data, New Database Query, and
find and select your database. Then proceed through the wizard.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
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

Excel Excel spreadsheets opening at top instead of bottom. 4
data from excel worksheet update with another excel worksheet 8
Pivot Table from linked spreadsheets 1
Querying Worksheets 5
Access Need help in making asset history in my current database. 1
Inserting Worksheets 1
Worksheet + 1 1
Can I reverse the axes of a populated worksheet (X to Y, Y to X)? 4

Back
Top