It sounds like you have the data in both a csv file and in a MS Access table.

If I am wrong, please tell me.

1 - Use the import / export wizard. This is part of the client tools for SQL Server as a seperate program (icon). Also, it can be called from both SSMS or BIDS (SSDT - newest version).

2 - As for MS Access, I was once certified in it but it is not on my resume. To many people think they know it but really do not. If you import data from the CSV using the delimited wizard (forms), it sizes the fields as text (255).

This is because you did not create the table first, then append to the table.

Access pretty much can do the same task but with a little more work (linked table to SQL Server, Append Query, use functions to trim or cleanup data).

3 - Either way, I suggest you create the table in SQL Server using SSMS GUI or straight TSQL.

Aftwards, append using the tool you are most familiar with.

Good luck