Ok, so what method of getting the data into SQL Server did you have in mind? There are quite a few ways to do it. You could write a VBScript with ADO code in it, and use ODBC to connect to the SQL Server. You could write similar code from within VBA for Access, and even create a form with a push button that would do the import. You could use SSMS and try the import/export wizard. You could also create an SSIS package to do it, or even open the file directly in Excel, and then import the Excel file using any of the previously mentioned methods. However, whichever method you choose, you're going to have to worry about data that doesn't fit the data type for a given column, so you might want to first verify your data in some way. Perhaps a test VBScript could help.

What we don't know is what the Access database has to do with the CSV file, or if there's even any relationship between the two, nor do we know anything about either the file or your objective in getting it into SQL Server, so we're a little shy on information. Can you please provide more detail?