InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 05:36:51 GMT20http://www.sqlservercentral.com/Forums/Topic1432298-148-1.aspxFrom Access to SQL Server, presumably?So you want to create a loop which iterates around all tables in a selected Access database, and for each table it should create the table in SQL Server and then populate it?Not easy at all. I'd just stick to the upsizing wizard.Wed, 20 Mar 2013 10:57:13 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1432298-148-1.aspxPhil, thanks for your reply....all i wanted to do i dynamically extract Access schema and create views to insert data into database....In other words all i wanted to do is process any Access file(irrespective of schema type) and insert data into databaseWed, 20 Mar 2013 10:51:38 GMTsandyinfowavehttp://www.sqlservercentral.com/Forums/Topic1432298-148-1.aspxCan you provide a bit more background?What do you want to do with the schema once it has been extracted?Mon, 18 Mar 2013 12:17:24 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1432298-148-1.aspxI was recently assigned a task of dynamically extracting Access schemas...How do i approach using SSIS..Any thoughts or suggestions would be highly appreciatedMon, 18 Mar 2013 12:10:19 GMTsandyinfowave