Sharepoint - Linked Tables - V.simple Q.

[Jonathan Davey]

Sorry for my cross posting, but wasnt sure which group to post to...!

Ive just discovered that access links tables with Sharepoint!

So powerfull and easy to use.

Changes on the website appear in the local mdb file.
Changes to the mdb file appear on the website.

My problem:

I have an PocketPC application that exports data to an mdb (ODBC) file of my
choosing.

The PPC application fails to export directly to the SP-linked table. But can
export to say a new identical table in the same mdb file. Nor can the PPC
app export to a QUERY table.

My question:

How do I get the data from my PPC_imported_table to populate the
SP_Linked_table?

Or in other words how do I get data from a standard_tbl to a Linked_tbl

Thanks

Jonathan

 

[Jonathan Davey]

Its a simple query is it not?

 

[John Nurick]

An append query, in fact.

Its a simple query is it not?