Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aguess
Starting Member
6 Posts |
 Posted - 2007-08-31 : 09:17:57
|
hii am linking an ingres table (called client_table) to my acces table (called name_table).i have to fill a new empty column in the ingres table with my accees table.i used this query to fill the names of clients from the access table to the ingres table ,any client is identified by a ref who is a client reference.UPDATE [client_table] INNER JOIN name_table ON [client_table].ref_client = name_table.ref_client SET [client_table].name = [name_table]![name] but when i executed the query ,the access asked me to give a value of the parameter name_table.name and the same for client_table.name after that i got a message tha tell me that i have to use an UPDATE query to write in the ingres table .can you give me hand to resolve this problem? |
|
|
pepig
Starting Member
10 Posts |
Posted - 2007-08-31 : 12:12:38
|
| Honnestly, I'm a rooky in the field of linking databases that were created by different software (especially since I've never used ingres). So I might be saying nonesense, BUT:All I know is that when you want to do it, tere's usually a bug because different softwares "speak in a different language". What I'd do is first export the access data in a .csv file (wich is almost universally supported) and then import it into ingres.And then you can do your UPDATE-query in ingres using only "ingres-files" |
 |
|
|
|
|
|
problem to update a linked table