Post reply

Check if the file is .mdb

  • September 24, 2007 at 5:27 am

    #118346

    Hi,

    I am using a foreach file to loop through a folder and pick a file. Then populate a Sql table.

    Now I want to check if the file is a mdb and then check if the mdb contains a table called "Customers". If any of these conditions fails, the file should be moved to the Error folder. If conditions pass, populate the Sql tables.

    How do I do this? Please specify the components to use.

    thanks

  • September 24, 2007 at 9:52 pm

    #735868

    no one 🙁

  • September 25, 2007 at 1:21 pm

    #736138

    By saying you are checking for mdb files, I assume that you are checking to see if it is a Microsoft Access database file. How do you know what the structure of the file is? Is there a limited set of structures that are valid?

    There are tools available to move data from Access to Sql-Server but you need to know more than "it is an Access database".

    Steve

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply