View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default 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