combining tables

[sedgely]

i have 2 Access tables that i would like to bring into SQL and combine them to make a single table. there is no data in either table yet, i just want to copy the structures.
is this possible?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[JayKusch]

I believe you can do that. Start from the SQL Server side w/ the database you are wanting to create the tables in.

Right-mouse click on the tables tab and choose
All Tasks..Import Data. Point your source towards you Access DB and set the target to the DB you are wanting to create the tables in.

Follow the next few steps and bingo ... your empty table structures, schema, should be created in SS.

Thanks

J. Kusch

 

[sedgely]

JayKusch
I have used the import wizard and pulled the tables into SS but they are still 2 seperate tables and i want them to be combined into a single table, any ideas?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[JayKusch]

Unless you you the transformation portion of the import in some fashion, I am not sure you will be able to accomplish this. You may have to create the tables and then combine them into one once they are on SS

Thanks

J. Kusch

 

[sedgely]

Thanks JayKusch
have now sorted this, ended up bringing both tables in seperately then manually copying from one to another.



Cheers, Craig
Si fractum non sit, noli id reficere

 

[JayKusch]

You may have to create the tables and then combine them into one once they are on SS EXACTY!

Thanks

J. Kusch