Import the monthly csv file into SQL Server

3 posts / 0 new
Last post
KG4LAC
Offline
Last seen: 1 month 1 week ago
Joined: 2022/09/18 - 19:48
Import the monthly csv file into SQL Server

Thought this would be a simple exercise.

Unfortunately, no.

Using "Suggest Types" or setting all columns to string in the SQL Import Wizard fails on the actual import due to a conversion error.

For those successfully importing the monthly csv into SQL

What are the 15 (0 to 14) colum data types?

What code page is correct? I tried the default 1252 (ANSI - Latin I) and checked Unicode and these both failed on the actual import due to a conversion error.

Thanks.