SELECT * INTO doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i am doing a SELECT * INTO <temp-access-table> FROM <sybase-link-table>, it hangs indefinitely. When i am using msjet40.dll Version 4.0.6218.0 the query works fine, but when i am using msjet40.dll Version 4.0.8015.0 this query hangs
If i do a record by record insert (by writing a piece of code in access module) it works fine. Please help.
 
Hi,


SELECT INTO creates a table, don't you want an INSERT INTO instead,
since it seems your table already existed?



Hoping it may help,
Vanderghast, Access MVP


Ganesh Nayak said:
When i am doing a SELECT * INTO <temp-access-table> FROM
Click to expand...
<sybase-link-table>, it hangs indefinitely. When i am using msjet40.dll
Version 4.0.6218.0 the query works fine, but when i am using msjet40.dll
Version 4.0.8015.0 this query hangs.
If i do a record by record insert (by writing a piece of code in access
Click to expand...
module) it works fine. Please help.
 
No i don't want insert into query. I want to create temp tables in MSACCESS from sybase link tables.
 
Back
Top