Can you do this and does it work?

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?
 
L

Lynn Trapp

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
 
A

aaron.kempf

Yes, it is quite easy

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