Linking excel cells to Access Fields

  • Thread starter Thread starter chiligoldva
  • Start date Start date
C

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
 
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.
Click to expand...

Data/Get External Data/New Database Query
 
Back
Top