Linking excel cells to Access Fields

[chiligoldva]

I have a user maintained spreadsheet. I have a database I
have created to pull down ftp data and parse it into 21
tables. This data updates the spreadsheet daily.
I would like to paste link these cells to the fields in
the tables so when the tables are updated daily, it
automatically updates the cells in the spreadsheet.
I have been using code for this, but there are at lease
3000 lines of code and this spreadsheet is getting huge
with all these lines of code (one for each line in the
spreadsheet).
Is it possible to use paste link between applications, as
it is internally between spreadsheets?
If this is a bad solution, can you tell me why it is not a
good solution. All these lines of code seem to be very
frustrating to maintain.
Thanks, Chiligoldva

 

[Jonathan Rynd]

I have a user maintained spreadsheet. I have a database I
have created to pull down ftp data and parse it into 21
tables. This data updates the spreadsheet daily.
I would like to paste link these cells to the fields in
the tables so when the tables are updated daily, it
automatically updates the cells in the spreadsheet.

Data/Get External Data/New Database Query

 

[Harlan Grove]

Data/Get External Data/New Database Query

I'd guess SQL.REQUEST would be closer to the OP's intent.