Sorry for the confusion.

I wanted to know the best way to import the structure, adjust it and then import the data into that.



>I'm confused. Do you want to change structure of the table or not?
>
>>
>>I'm importing a large foxpro table into SQL Server.
>>
>>The import using the Import Export Wizard worked created the table and I have my data but I want to adjust the structure of the table .
>>
>>When I try to amend the structure I get a warning
>>
>>Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible.
>>
>>How can I import my data into a table which I have already set up so I don't have to change the structure (I'm actually trying to make one of the items a PK.)
>>