If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Not able to use append query
In my database, I have one table (Inventory) and a link to an excel sheet
(City). When I try to build a small append query to attach the City sheet to the Inventory table, the append query does not give me the option to append to the Inventory table. Why is that? The datatypes match, the columns match, and I am stuck. Please help. |
#2
|
|||
|
|||
Not able to use append query
Use an update query.
"GeeseWatcher" wrote: In my database, I have one table (Inventory) and a link to an excel sheet (City). When I try to build a small append query to attach the City sheet to the Inventory table, the append query does not give me the option to append to the Inventory table. Why is that? The datatypes match, the columns match, and I am stuck. Please help. |
#3
|
|||
|
|||
Not able to use append query
Well, we don't want to update data in the table. We just want to add data to
the existing table. There is no issue with the links to the excel sheet, but I can't get the query to acknowledge the main inventory taable. "Golfinray" wrote: Use an update query. "GeeseWatcher" wrote: In my database, I have one table (Inventory) and a link to an excel sheet (City). When I try to build a small append query to attach the City sheet to the Inventory table, the append query does not give me the option to append to the Inventory table. Why is that? The datatypes match, the columns match, and I am stuck. Please help. |
#4
|
|||
|
|||
Not able to use append query
add a column called "City" and then try appending the data.
"GeeseWatcher" wrote: Well, we don't want to update data in the table. We just want to add data to the existing table. There is no issue with the links to the excel sheet, but I can't get the query to acknowledge the main inventory taable. "Golfinray" wrote: Use an update query. "GeeseWatcher" wrote: In my database, I have one table (Inventory) and a link to an excel sheet (City). When I try to build a small append query to attach the City sheet to the Inventory table, the append query does not give me the option to append to the Inventory table. Why is that? The datatypes match, the columns match, and I am stuck. Please help. |
#5
|
|||
|
|||
Not able to use append query
Do you mean add new records to the table, or add values in fields in the
existing records? You description is a bit vague. You use an Append query to add new records to a table. You use an Update query to modify value of fields in existing records. Also, be sure, if it is indeed appending you are trying to do, you are not attempting to add records to the liked excel sheet. You can't do that directly from Access (sort of), you have to use the Execute method with SQL specifically tailored to update Excel files. "GeeseWatcher" wrote in message ... Well, we don't want to update data in the table. We just want to add data to the existing table. There is no issue with the links to the excel sheet, but I can't get the query to acknowledge the main inventory taable. "Golfinray" wrote: Use an update query. "GeeseWatcher" wrote: In my database, I have one table (Inventory) and a link to an excel sheet (City). When I try to build a small append query to attach the City sheet to the Inventory table, the append query does not give me the option to append to the Inventory table. Why is that? The datatypes match, the columns match, and I am stuck. Please help. |
Thread Tools | |
Display Modes | |
|
|