Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 31st, 2007, 09:23 AM
Registered User
 
Join Date: Apr 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Make Table Query

I need some ideas. I am working with a large file of over 3 million records. I am trying to query with LEFT([fieldname],9) into a Subscriber Number field and make a table of the return. Although I can run a select query without incident, when I try to use a Make Table Qry I get the error message "Invalid Arguement". I need the table but can't export to Excel or cut/paste due to the file size. Any suggestions?

 
Old May 31st, 2007, 09:44 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

First try makig the table yourself adn then running this as an Append query.

If that doesn't work, you can code the entire operation easily enough.

Does the append work? If not, I will post the code you need.


mmcdonal
 
Old June 1st, 2007, 06:22 AM
Registered User
 
Join Date: Apr 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Although it took close to 2 hours to run, using the append versus the make table query worked. Thanks!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a Make Table Query produce a Linked table? kronik Access 5 May 16th, 2006 06:17 AM
Make table Query and Datepart marshaji Access 1 June 21st, 2005 12:36 PM
Make Table query : table in Another Database marnik Access 1 March 19th, 2005 12:39 PM
Error on Make-Table Query In Union Query rylemer Access 1 August 20th, 2003 07:42 PM
Error on make table Query rylemer Access 2 June 19th, 2003 10:38 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.