importing qry as tbl

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

Guest

I noticed one can import a query in one access d-base into another, as a table.

Trying to do it with code; it seems to me the code below should work, but it does not and I'm not sure why, any tips?

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\Bob\Clients.mdb", acQuery, _
"qryBobsClients", acTable, "tblBobsClients"

Thanks,
pepe
 
well, i know it is possible to do this with import dialog. programatically
you can do this using select into (or "make table") query


--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com



pepenacho said:
I noticed one can import a query in one access d-base into another, as a table.

Trying to do it with code; it seems to me the code below should work, but
Click to expand...
it does not and I'm not sure why, any tips?
 
I haven't done this before, so this is just a guess, but
you may want to try changing the acQuery to acTable, but
still specify the query name.

-Ted Allen
-----Original Message-----
I noticed one can import a query in one access d-base into another, as a table.

Trying to do it with code; it seems to me the code below
Click to expand...
should work, but it does not and I'm not sure why, any
tips?
 
Back
Top