Invalid argument

[JeffT]

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

 

[KARL DEWEY]

Post your SQL.

 

[JeffT]

Post your SQL.

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

Don't you need the mdb file?

 

[KARL DEWEY]

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

Post your SQL.

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

Don't you need the mdb file?

 

[JeffT]

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

Post your SQL.

:

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

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

Don't you need the mdb file?

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