Posted by Jonathan Roberts on 02/04/07 04:14

Wes Groleau wrote:
> Jonathan Roberts wrote:
>> Wes Groleau wrote:
>>> When I try to import from Access, the DTS wizard only allows me to
>>> import tables and queries. OK, I'm not surprised the "macros" and
>>> reports don't come over.
>>>
>>> [snip complaint details].
>>
>> Have you tried using the Upsize wizard?
>
> The upsize Wizard does not work. On the third or fourth
> page, it pops up a box saying nothing but "Overflow"
> Nothing happens in SQL Server.
>

Glad you mentioned it. You have hit the number one common problem with
the wizard. It does work but you have to overcome this issue. Google
it to find many pages of info. One KB is here:
http://support.microsoft.com/kb/272384. I don't remember the exact fix,
but it wasn't hard to resolve.

If you don't want to go that route, you can certainly pull out all your
queries manually and create views in SQL Server. I don't know of an
automated way to do this. If you have a lot of queries, this way may
not be practical.

Good luck and keep posting if you need help.

Jonathan

[Back to original message]