OverFlow error msg

[H1004]

I have an Access database (.mdb) file from the vendor, which support one of the application. However, I want to the back-end converts to SQL Server instead.
So I've done two ways:
First:
I have tables already created in SQL Server. So I create an Access project with those tables. So when user click on upload data, it gave me an error msg saying "Cannot Find Database: DbConnection"

Second:
Open up Access file given by the vendor. Go to upsizing wizard. Select use Existing Database, when it ask for Datasource, I select Machine DataSource, select the appropriate ODBC. But when I click next, it gave me "OverFlow" error msg.

Either way I've tried, it doesn't work...Any suggestion on why i'm getting this or how I can go about solving it or suggestion on different method.

Thank you

 

[rebooot]

Try to setup the ODBC connection through the control panel under ODBC connection setup and test it first. After you do that run your second step using the new ODBC source you have created. This should work, otherwise let us know.

Good luck.

Rebooot