just for grins, can you attach to SQL Server from Access and create a Make Table query to create the columns you need? I'm just wondering because maybe the sizes/types of the columns in Access are not big enough to hold the data you're trying to put in them. Create a quick view in SQL Server containing all the columns you need but only a few rows and then base a Make Table query on that view and see what field types and sizes you Access creates.