Export tables from SQL 2005 to Access 2003

Hi,
I have a Table in SQL 2005 with columns having datatype nvarchar(255). When i Export this table to Access the Datatype get changed to Memo.
However I want the Access datatype to be Text. I tried changing the Datatype at Access level, but it gives me an memory error.
The machine being used is a Server and is currently not being used by any other major Processes apart from SQL 2005.
I understand the reason maybe becoz Text in access only stores 255 character and my nvarchar column in SQL stores Unicode data as well.
Could some one please provide some alternative so that I may export the Data into Text Data type in Access.
Thanks

I guess you could first export it to excel or a flat-file and then to Access from there using a single SSIS package. [*-)]

Could you create the MDB in Access, with the tables and columns, then export to the existing MDB?
On the Text(255) column, you need to set the "Unicode Compression" property to Yes.