| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should I be using Access?
Hi!
I have 4 people on a network working on separate Excel "stations" (each with its own VBA code) that use a single database which is an independent Excel Workbook. Each user imputs new things to the central data base. However, my central data base is approaching the dreaded 65535 records. Should I migrate the data base to Access? Or would I be better off attaching a second data base (or excel worksheet) to the original? How can I use Excel to imput data (records) into access? Thanks and Best Regards, Albert C |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I be using Access?
Depends how familiar you are with Access. If you are comfortable with it then
I would definitly look to migrate over. As you said it is a database. Reading and writing to Access is fairly easy. A quick search of ADO DB Recordsets should point you in the correct direction... Just my 2 cents... -- HTH... Jim Thomlinson "Albert" wrote: Hi! I have 4 people on a network working on separate Excel "stations" (each with its own VBA code) that use a single database which is an independent Excel Workbook. Each user imputs new things to the central data base. However, my central data base is approaching the dreaded 65535 records. Should I migrate the data base to Access? Or would I be better off attaching a second data base (or excel worksheet) to the original? How can I use Excel to imput data (records) into access? Thanks and Best Regards, Albert C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
| Excel Access and Oracle | Excel Discussion (Misc queries) | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
| Excel and Access talking | Excel Discussion (Misc queries) | |||
Linear Mode
