Using UpSize to SQL Plugin via Code

[DerickD]

Hey All,

I have written some code that :
1) Imports from text file
2) Appends it to a Table
3) Sorts and Updates the table

And now I want to upsize this new to our SQL server we have......

I have downloaded and installed the 'Microsoft Access Upsize Tool' for upsizing some table to our SQL 7.0 server.
It works fine, but I want to 'Access' the tool via Code, so the User Selects criteria and presses the button, and Booom you have a new table on your SQL.......

(I know, I know, that all this could be done on SQL from the begining, but it does not make it very Admin friendly)

Can you help me..

 

[DerickD]

Do not worry I have found what needs to be done...

You can use the

DoCmd.TransferDatabase acExport, "ODBC",
[\code]

expresion ..(but add all the parameters...)