transfering data from access query to access table

[abrown]

I have an Access database (read only) and want to transfer the data from a query (191,000 records) into another Access database table.

Can I do this with the TransferDatabase action in a Macro?

I am not sure what format the Source is supposed to be in. Can someone help me out.

note: I also tried Importing the query and I got this error "decimal fields percision too small to accept numeric you attempted to add."

Thanks.

 

[Justinnz]

What about changing the query into a make table query and setting it to make a table in another database.

You can then run the SQL for this in a macro if need be.

 

[abrown]

I get the same error about the "decimals field percision too small..."

 

[Joe4]

Per forum rules, please do not start a new thread for an existing question. Continue on in the same thread:
http://www.mrexcel.com/board2/viewtopic.php?t=283175&highlight=