Create SQL Table from existing Access Table

[gwoman]

Hi ...
Can I create and SQL table from an existing Access table? And if so ... can someone provide an example of the syntax ... thanks much .... have a good one!

gwoman

 

[SQLSister]

Access has a wizard which will do this. Be careful though as it doesn't always do the best job of selecting datatypes.


"NOTHING is more important in a database than integrity." ESquared

 

[djj55]

If you use import watch your character column sizes as they tend to be 255 even if Access said it was text(2).
djj

 

[LNBruno]

Is thar some reason why ye wouldna jus' create th' table yersef? As pointed ou', fixin' data types an' sizes could very easily outweigh th' shortcut ye're lookin' fer.

Best be learnin' t' be talkin' like a buccaneer on this day!

< M!ke >
[small]I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people. - Tiki Barber[/small]

 

[gwoman]

Aye Mike ... Happy International Talk Like a Pirate Day to you!

Thanks all for your input ... I ended up just creating the tables myself as there were only 6 and they were small tables. I was kind of just looking for something to use in the future should I run across this again with on a larger scale ...

Thanks again ...

Ahoy ... gwoman

 

[JackVam]

One other way would have been to export to Excel and then import into SQL Server - which would automatically create the tables for you , the problem is the data types don't match exactly

All the IT jobs in one place -

http://www.ITjobfeed.com

 

[PRPhx]

You can also import from SQL (Enterprise) from your Access db and let SQL Server create the tables.

Either way, you have to check data types and lengths. You can also save as a DTS package if it's something you do over and over.