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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.