Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Access Database Connection problem in Excel XP 2002
I want to get data from Access database into Excel worksheet. But it gives
the following error and doesn't connect to the datbase. "Could not open table 'MSysAccounts' in the workgroup information file. (Error 3173)" I have tried all solutions even reinstalled Office XP 2002 but in vain. Is there any way to solve this problem urgently. Thanks - Ms. Sarwat Malik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Access Database Connection problem in Excel XP 2002
Looks to me like some ODBC settings
dont allow you to find system tables. start a new database query in the 'Choose column' Page of the wizard click options make sure that 'system tables' is CHECKED hth keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Sarwat Malik" wrote: I want to get data from Access database into Excel worksheet. But it gives the following error and doesn't connect to the datbase. "Could not open table 'MSysAccounts' in the workgroup information file. (Error 3173)" I have tried all solutions even reinstalled Office XP 2002 but in vain. Is there any way to solve this problem urgently. Thanks - Ms. Sarwat Malik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Serial Letter- Connection with Excel database | Excel Discussion (Misc queries) | |||
wanna use print preview in excel 2002 without printer connection | Excel Discussion (Misc queries) | |||
ado connection string for excel 2002 | Excel Programming |