News

A "Text Import Wizard – Step 1 of 3" dialog box will appear. Browse for the Word form you want to import and click on it. Click "Delimited" and click "Next." ...
Values in a CSV file are separated by commas. If your CSV file uses different separators, such as semicolons or tabs, select them instead of "Comma." Click "OK" to import the CSV file in OpenOffice.
Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.