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...
 
Back
Top