|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 31st, 2008, 09:49 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Can you do this and does it work?
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? 
|
|
#2
July 31st, 2008, 11:42 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can you do this and does it work?
On Thu, 31 Jul 2008 13:49:00 -0700, Golfinray
wrote: 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
|
|
#3
August 1st, 2008, 02:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can you do this and does it work?
Yes, it is quite easy
a) store all your data in a database b) query out of the database on the excel side On Jul 31, 1:49*pm, Golfinray wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
