We receive a .mdb daily from client and would like to automate the process of getting the one table out of the Access .mdb and have it imported into the SQL Server 2005 database. Ideally they would sent us a flatfile/csv of some sort but that is not in the forseeable future.
Would like to set up a process of getting this data extracted.