table structure

[Guest]

I managed to import a database from mssql to msaccess. How can I retain the
table structure and relationships of the tables during importing?

Thks.

 

[Joseph Meehan]

I managed to import a database from mssql to msaccess. How can I
retain the table structure and relationships of the tables during
importing?

Thks.

Table structure you should be able to do by manually tweaking the import
and then save the import specifications as an import scheme.

 

[Guest]

don quite understand what you mean by 'tweaking the import'. Can give me more
info what exactly needs to be done.

Thks for yr help

 

[Joseph Meehan]

don quite understand what you mean by 'tweaking the import'. Can give
me more info what exactly needs to be done.

Thks for yr help

When importing data using the import wizard about the third or forth
step allows you to chose the filed type. The wizard guesses and you get to
change it. For example the wizard only looks at the first few records and
may see only numeric information while other records also contain alpha
characters. Knowing this you can change the field type to text. This allows
you to match table types as well. For example even if a field only contains
numeric information, it may in real life be text as in serial numbers you
don't want to confuse 00125 with 0125 which going to a number filed would do
as both would be recorded as 125 with no leading zeros.

 

[Guest]

what abt the existing table relationships from mssql (eg: table 1 pkey is
linked to table 2 pkey). can they be retain during importing or i need to
manually create the relationship in msaccess.

thks very very much for the help

 

[Joseph Meehan]

what abt the existing table relationships from mssql (eg: table 1
pkey is linked to table 2 pkey). can they be retain during importing
or i need to manually create the relationship in msaccess.

I believe that all you can import is the data, any relationships need to
be re-established.

thks very very much for the help