Results 1 to 1 of 1
2002-12-30, 08:02 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
link excel with access query (Excel 2000)
<P ID="edit" class=small>(Edited by Leif on 30-Dec-02 09:02. )</P>Cross-posted and replied to in Post 208979 in Access.
Further replies there please!
<img src=/w3timages/blackline.gif width=33% height=2>
Can i link an excel table with an Access query ?
In order for my Access database to be connected with a a further accountant program, the developers required to have the source data converted into an excel table.
In order to do it, i have converted the following access query into execl:
SELECT DISTINCTROW Orders.paymentid, Orders.invoicedate, Customers.Customerid, Customers.CompanyName, products.Productid, products.code, [order
FROM (Customers RIGHT JOIN Orders ON Customers.Customerid = Orders.customerid) INNER JOIN ([order details] INNER JOIN products ON [order
details].ProductID = products.Productid) ON Orders.OrderID = [order details].OrderID
ORDER BY Orders.invoicedate;
i will have to export the above access query into an excel table several times in the month.I will have to do it manually, by selecting
Toole-office links-excel.Can i automate the proces,somehow by linking the excel table ito the access query, so that each time i change the data in the
query, the data in the excel table are updated ?