I am trying to import an Access table into SQL Server using the SQL Server Import and Export Wizard.
I created the SQL Server table using the same field names that are in the access table.
After selecting the Source and Destination tables in the wizard I get the message "Found 7 unknown column type conversion(s)". The seven fields are all text fields in access that I am mapping to nvarchar fields in SQL server. There are other text fields that map successfully. Can anyone tell me what my problem might be?