Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Dinesh Asanka How to Read Excel Cells from SQL Server Integration Services RE: How to Read Excel Cells from SQL Server Integration Services

  • April 28, 2010 at 9:17 pm

    #1159389

    Ian Yates (4/28/2010)

    Now if only they'd do one for FoxPro....... 🙂 (we link to a number of third party systems that use FoxPro databases)

    You do know that a FoxPro dbf is just a flat file with a header? It's been a decade since I've worked with it, but I remember the company having problems exporting data from a mainframe computer into a FoxPro dbf, and having issues. We ended up exporting it into a flat file, and appending the header.

    So, if you can strip off the header, you can then just do a bulk import...

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2