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.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

As an Object Linking and Embedding Database (OLE-DB) provider, the 10G Control enables Microsoft Excel to import and analyze Oracle data.