Adding multiple data to large DB on server

Hi!

I want to add quite a large amount of data (~5MB) from an Access DB on my computer to an existing Access DB (~50MB) on a web server. What would be the most appropriate way of doing this without having to download/upload the entire original DB? I was hoping it would be possible to transfer the "update" DB to my server and then make the transfer on the server.

When I use the SELECT INTO statement the error message says that "Case" is expected where I define my source (my update table).

Thanks, Martin

The easiest way would be to link the Web Server DB to the 5MB DB on your Desktop. Then copy and paste. between tables. The most efficient way, after linking the DB's together, would be to write an Insert statemtn which won't give you the same problems, because the 5 mb DB will think that both DB are together (becuase they are)

To help you with the way you started, You would need to post more info. SQL Statement, connection type, etc

S-

I followed sbaxter's advice and linked the two tables. I then only have to make one connection to move the new data to the existing database. Quite neat!

The whole code:

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("myPath\myDB.mdb"))

SQL = "INSERT INTO myTable SELECT * FROM updateDBTable"
conn.execute(SQL)

Just use the original database as a template when creating the update database, so that all the new data is formatted the same way as the old, with column names, data format etc.

Thanks for the help!

Martin