copyng table 1

[ter79]

I'm trying to use this code to copy data from a table existing on another database to the current database that is calling the code from:

DoCmd.RunSQL "SELECT * INTO Rating IN C:\Documents and Settings\user\Desktop\Test.mdb FROM Rating;"


But I keep getting an error message "Query input must contain at least one table or query"

Thanks in advance

 

[PHV]

And this ?
DoCmd.RunSQL "SELECT * INTO Rating IN 'C:\Documents and Settings\user\Desktop\Test.mdb' FROM Rating;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ter79]

That helped with the error. However, all it's doing is deleting the current table in the destination database and recreating it. It's not being over any data unless I forgetting something else or misunderstanding this statement.

Any ideas

 

[ter79]

disregard my last post... It was working correctly but it's doing the exact opposite of what I want.

 

[PHV]

And this (maketable)?
DoCmd.RunSQL "SELECT * INTO Rating FROM Rating IN 'C:\Documents and Settings\user\Desktop\Test.mdb';"
Or this (append)?
DoCmd.RunSQL "INSERT INTO Rating SELECT * FROM Rating IN 'C:\Documents and Settings\user\Desktop\Test.mdb';"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ter79]

I got it working with a RWOP query.