linked tables continued

  • Thread starter Thread starter colmkav
  • Start date Start date
C

colmkav

sorry but CopyObject wont work because it just copies the link and the
whole point is that I dont want a linked table

Is there an "import table" function I can use?

Colm
 
Not sure what you are asking. Did you intend to attach this post to a
previous chain of messages?
 
DoCmd.TransferDatabase allows you to import, export or link. You'll need to
specify the source database, what type of object, the object name and, for a
table, whether you want to copy just the structure or structure and data.

You could also create a make-table query, with data coming "indirectly" from
a linked table or "directly" from an external source (although there's no
real difference between the 2).

HTH,
 
Back
Top