Copy linked table and Paste as Data

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

Guest

I have a linked table whose primary key data type needs to be text instead of
numeric to create a specific join. I want to create a macro that will:

a) Copy my linked table - table name SURVEY
b) Paste the table in the same db as WEB_SURVEY with "Structure & Data"
c) Change the data type of the primary key from numeric to text

Can someone please help me out? I'm CLUELESS!!!
 
JTurner,

It is possible to do what you are asking (you would use a
TransferDatabase action in your macro to achieve steps a and b combined,
and a RunSQL action to run a couple of DDL queries using ALTER TABLE
statements).

However, it is probably not necessary to go to these lengths. You can
just make a simple select query based on your Survey table, with a
Format() function to produce the text version of the primary key field,
and then use this query as the basis for your other purpose.
 
Back
Top