How to automatically create a target table for a data import set?

[raking08]

I have been asked to migrate an existing (and very complex) structured knowledge repository to ServNow ( and this is my first exposure to SN so please forgive a dumb question). I realize that I will need to create the main data tables one column at a time from scratch in order to have all the proper configuration (7 tables 50-120 columns each lots of ref fields)

BUT I have another 170 tables that I have in Excel that I can load to an import set as they are more simple ( no reference fields etc) These each have 10-70 columns each and all unique. These will only be referenced by records in the main data tables.

I need to transform these to   a set of 170 tables ( a one time exercise) What I hope to do is to automatically create the custom target table from the individual import sets.

Is this possible?

Is there a better way?   Can MS Access be used to create tables via ODBC Connection? (For instance I can create these kinds of table directly from MS Access in SharePoint in one click)

Many Thanks

R

[kkraju]

I am trying to do the import as explained in setps1 and 2 and could get the table and columns created, ranking08, could you please share the excel template which you used to create them.

Thank You

KK