How to move table definitions?

  • Thread starter Thread starter Siegfried Heintze
  • Start date Start date
S

Siegfried Heintze

What is the easiest way to move table definitions between various databases?
For example: if I have a excel spreadsheet with column headers, how can I
move the table definition (excel seems to be able to detected data types like
dates and integers and strings) to MSAccess or SQL server or MySQL?

I was going to interrogate the data set for the column types and use ADOX to
create the table definitions. The data set won't give me primary key and
foreign key information though. Is there an easier way?

Thanks,
Siegfried
 
Siegfried,

You can do as much as you want, but just use the script option to Create the
definition and run that in the SQL manager cost you probably ten times as
less as any other option.

Just my opinion.

Cor
 
Back
Top