From 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.