Upsizing from access 2000 db

I have an access 2000 mdb file that I want to upsize to SQL v7.0.

I tried using the upsizing wizard [Access 2000] as well as the import/export wizard [SQL] and I find that it always wants to create text elements as nvarchar.

This is a problem for me as I need them to be varchar.

I generated an SQL script that creates the table structure for me ahead of time and made sure all nvarchar where now varchar. Created the structure in the SQL db but when I use any of the wizards, it overwrites my table structure and everything becomes nvarchar again.

The only way I can see to get this done properly is while using the SQL import wizard you can Transform the tables, but there are so many of them and things are tedious to get done this way.

Does anybody know how I can either:

1) Tell SQL to use varchar instead of nvarchar for the type?
2) Only import data and not the actual table structure (or at least not have it overwrite the structure on me)?

Any help would be appreciated.

Thanks