Can you do this and does it work?

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

Can you link an excel file to a linked table on the BE of your database so
that anytime users add data to the spreadsheet OR add data the the table
through a form, it is stored on the table? If so, are there problems
associated with that?
 
Can you link an excel file to a linked table on the BE of your database so
that anytime users add data to the spreadsheet OR add data the the table
through a form, it is stored on the table? If so, are there problems
associated with that?
Click to expand...

You can link an excel file IN your database, but you will have to do
some querying to connect it witha specific table in the database.
Lynn Trapp
www.ltcomputerdesigns.com
 
Yes, it is quite easy

a) store all your data in a database
b) query out of the database on the excel side
 
Back
Top