Can you do this and does it work?

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

 

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

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

 

[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