Append record from Access file to table in SQL Server

[H1004]

I have an Access (.mdb) database called (LocalData.mdb) with just tables & no form. When it opens, I want it to append the record to another database, which happen to be connected to the SQL Server. What I did was create an append query. Down at the bottom
I clicked Another Database. And it wants me to enter the path. Then I enter
the path C:\Program Files\DatawarehouseData.adp
Somehow this method doesn't work. It gives me an error message that said “Unrecognized database format: PathName….” Please advise. Any suggestion is greatly appreciated

 

[cmmrfrds]

Please reference your other post.

 

[rebooot]

Try uploading your table to the SQL server using the upsize tool that comes with Ms-Access. Once you are in the SQL server environment you will be able to append any data you need to whatever table. If you need exact code for this check the SQL server group in Google.

Rebooot

 

[H1004]

That's where I run into trouble too. I tried to upsize my database to SQL Server, and I get an overflow error messages. I even try creating a new ODBC connection, but I still get this "Overflow" error when I tried to upsize it again. Do you know why I'm getting this error?

 

[H1004]

I have a dilemna where I have a manufacture (.mdb) Access database where the data will be downloading into. I don't want to modified anything in this Access database.
What I want is for this data to end up the in datawarehouse.
However, this manufactured Access database is stored in the local PC.
So my first thought is maybe I'll do an Append query, but it works best when both file is .mdb Access file. But in my situation, one is .mdb and .adp.
So what I want to get out of this append query is hopefully transfer all this local Access data into the ADP file table, which is hook up to the datawarehouse(SQL Server).
This approach might be all wrong, so I'm looking for a way to do this.

 

[cmmrfrds]

I showed a way in your other post. thread701-819770

You seem to be under the impression that there is an "ADP file table". An Access project (adp) is an application that has an ole-db connection to a sql server database. The adp does not contain data.

The simplest way for you to handle transferring the data from the mdb to sql server is by linking the sql server tables to your mdb and then they can be treated like any other access table.