Linking Worksheet to Database?
 

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

Thank you

Linking Worksheet to Database?
 

In Access choose File, Get External Data, Link.

To make this work properly I suggest you range name your data set in Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RoadKill" wrote:

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

Thank you

Linking Worksheet to Database?
 

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.

"Shane Devenshire" wrote:

In Access choose File, Get External Data, Link.

To make this work properly I suggest you range name your data set in Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RoadKill" wrote:

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

Thank you

Linking Worksheet to Database?
 

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


"RoadKill" wrote:

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.

"Shane Devenshire" wrote:

In Access choose File, Get External Data, Link.

To make this work properly I suggest you range name your data set in Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RoadKill" wrote:

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

Thank you

Linking Worksheet to Database?
 

Ah, that did the trick. Thank you

"Shane Devenshire" wrote:

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


"RoadKill" wrote:

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.

"Shane Devenshire" wrote:

In Access choose File, Get External Data, Link.

To make this work properly I suggest you range name your data set in Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RoadKill" wrote:

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

Thank you