News

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.
Jack Wallen explains how to add data into a MySQL table from the command line.
Type a command beginning with bcp using the following example as a guide:bcp my_database.sales_table in c:\sales_files\january_sales.csv -t, -U salesloginNote that bcp uses several command-line ...
When you import a spreadsheet into an OpenOffice.org database, you lose any text styling, number formatting, macro scripts or charts that you previously used to enhance the data.