Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Osmar Mateus
 
Posts: n/a
Default Queries from Excel 2003 to Access


How many queries may I have in a spreadsheet?
Is there a limit?
Apparentily I reached a limit and I am receiveing an error message. I
am using a Portuguese version so I don´t know the english message.


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=522655

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Queries from Excel 2003 to Access

If you'll copy the text of the Portuguese message, you can paste it
into the translator at www.Dictionary.com (after selecting Portugese to
English, of course). That will help people here to diagnose and fix
the problem.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Osmar Mateus
 
Posts: n/a
Default Queries from Excel 2003 to Access


Dave

The message in Portuguese is: "[Microsoft][Driver ODBC para Microsoft
Access] Número excessivo de tarefas de cliente."

I would translate to: [Microsoft][Drive ODBC for Microsoft Access]
Excessive number of tasks for the client."

Thanks for your help.

Osmar


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=522655

  #4   Report Post  
Posted to microsoft.public.excel.misc
Osmar Mateus
 
Posts: n/a
Default Queries from Excel 2003 to Access


I think that the message is: "Too many client tasks".

I have reduced the number of queries and it worked. The problem is that
I need to insert more queries ...


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=522655

  #5   Report Post  
Posted to microsoft.public.excel.misc
Osmar Mateus
 
Posts: n/a
Default Queries from Excel 2003 to Access


Microsoft has informed me that there is a limit of 64 queries for a
workbook. I solved the problem using macros.

Thansk to the people who tried to help me.


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=522655

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 not understanding Access 2003 "like" Martin Excel Discussion (Misc queries) 0 November 4th 05 12:15 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Using Excel Worksheets like Access Queries Lab Dude Links and Linking in Excel 2 August 12th 05 01:26 PM
Excel 2003 Add-in: Access Links Spiderman Steve Excel Discussion (Misc queries) 0 June 22nd 05 03:36 PM
Changing the format of an Excel output file made by Microsoft Access Amir Excel Discussion (Misc queries) 2 May 1st 05 12:57 AM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"