Generate Create Table Scripts

T

Tom Collins

I'm looking for code that will automatically generate a Create Table script
for each of my Access tables. When I export my tables to text, I want to be
able to re-import them with a minimum of fuss.
I tried a Google search with no results.

Thanks.

--


Tom Collins
tom.collins[at]cobbcounty.org

(Replace the [at] to email me)
 
J

Jackie L

If you are importing in text, you do not need to create a table first. Use
Import Specifications to create your table layout and import using those
specs. You can then use code or macros to automatically import, depending on
what you are comfortable with.

Import Specs can be found when importing text, go to the advanced tab or
save your import just before completing.
 
T

Tom Collins

If it was just one or 2 tables, that would be fine. But I have about 50
tables. Also, they won't be loaded into the same database so I still won't
have the import specs. Thanks anyway.

Jackie L said:
If you are importing in text, you do not need to create a table first. Use
Import Specifications to create your table layout and import using those
specs. You can then use code or macros to automatically import, depending on
what you are comfortable with.

Import Specs can be found when importing text, go to the advanced tab or
save your import just before completing.

Tom Collins said:
I'm looking for code that will automatically generate a Create Table script
for each of my Access tables. When I export my tables to text, I want to be
able to re-import them with a minimum of fuss.
I tried a Google search with no results.

Thanks.

--


Tom Collins
tom.collins[at]cobbcounty.org

(Replace the [at] to email me)
Click to expand...
Click to expand...
 
T

Tom Collins

No one else knows of how to do this?
What I'm asking for is basically the same as SQL Server has built-in. I
could easily write my own in a few hours, but I thought for sure someone
else must have already done it.

A quick answer would be most appreciated.
 
D

Douglas J. Steele

If I recall correctly, Kliksoft has a product that can do this. Take a look
at http://www.kliksoft.com/

SSW has something as well:
http://www.ssw.com.au/SSW/Products/ProdSummaryList.aspx

I'd also expect FMS to http://www.fmsinc.com

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Tom Collins said:
No one else knows of how to do this?
What I'm asking for is basically the same as SQL Server has built-in. I
could easily write my own in a few hours, but I thought for sure someone
else must have already done it.

A quick answer would be most appreciated.

Tom Collins said:
I'm looking for code that will automatically generate a Create Table script
for each of my Access tables. When I export my tables to text, I want to be
able to re-import them with a minimum of fuss.
I tried a Google search with no results.

Thanks.

--


Tom Collins
tom.collins[at]cobbcounty.org

(Replace the [at] to email me)
Click to expand...
Click to expand...
 
Top