Invalid argument

G

Guest

I get an invalid argument msg in make table query but not in select query
using exactly the same query.
 
G

Guest

KARL DEWEY said:
Post your SQL.
Click to expand...

SELECT [Tashman data06].*
FROM [Tashman data06]
WHERE ((([Tashman data06].[Code Area])="6045"));

Don't you need the mdb file?
 
G

Guest

Not need the .mdb but wanted to see your SQL for the make table query.

JeffT said:
KARL DEWEY said:
Post your SQL.
Click to expand...

SELECT [Tashman data06].*
FROM [Tashman data06]
WHERE ((([Tashman data06].[Code Area])="6045"));

Don't you need the mdb file?
Click to expand...
 
G

Guest

KARL DEWEY said:
Not need the .mdb but wanted to see your SQL for the make table query.

JeffT said:
KARL DEWEY said:
Post your SQL.

:

I get an invalid argument msg in make table query but not in select query
using exactly the same query.
Click to expand...

SELECT [Tashman data06].*
FROM [Tashman data06]
WHERE ((([Tashman data06].[Code Area])="6045"));

Don't you need the mdb file?
Click to expand...
Click to expand...

SELECT [Tashman data06].* INTO sistersdata
FROM [Tashman data06]
WHERE ((([Tashman data06].[Code Area])="6045"));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Argument (error 30001) 9
???Invalid argument when doing make table query 1
update query ODBC--call failed 3
Append Query Error 1
invalid argument 3
Unexplained Error "Invalid Argument" 2
Make Table query not-so-wizardly - most frustrating! 3
Append query/ make-table query has suddenly quit working 1

Top