TRUNCATE the table, adjust the structure and SSIS import package and import data.
>
>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.)
>>>
--sb--