Sqlpro import csv into table12/7/2023 ![]() ![]() Handle the text delimiter of double quotes.Automatically create a table based on the CSV layout. ![]() LogParser can do a few things that we couldn’t easily do by using BULK INSERT, including: Even though this little tool hasn’t been updated since 2005, it has some nice features for loading CSV files into SQL Server. LogParser provides query access to different text-based files and output capability to various data sources including SQL Server. LogParser is a command-line tool and scripting component that was originally released by Microsoft in the IIS 6.0 Resource Kit. Before there was Windows PowerShell, there was LogParser
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |