473,397 Members | 1,960 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)

Hallo Zusammen,

in der Access Datenbank mit Produktionsdaten werden tägliche
Auswertungen benötigt. Zur Zeit gibt es einen Tagesauswertung als
Aceess Bericht. Eine zukünftige Anforderung besteht darin, die
zusammengefassten Tages-Leistungen (1 Datensatz) als neue Zeile in ein
vorhandenenenes Excel-Arbeitsblatt automatisiert (VBA) zu exportieren.
Die Möglichkeit "DoCmd.TransferSpreadsheet acExport" ist da nicht
geeignet, da ich nicht jedesmal ein komplettes Arbeitsblatt im Excel
haben will, sondern nur einen "Datensatz anhängen". Auch das Excel
monatlich, je Tag fortschreibend neu erstellen scheidet aus, da 3
Spalten je Zeile in Exel manuell ergänzt werden müssen. Die
ergänzenden 3 Felder (Spalten) liegen nicht im Access vor, um die
Daten ausschließlich aus Access im Excel zu übernehmen. Auch eine
direkte Verknüpfung der Exel-Tabelle ins Access ist netzwerkseitig
nicht möglich.
Kann mir jemand einen Lösungsansatz, evtl. mit Selection nach Datum
aus der Access-Abfrage aufzeigen.

MfG Andreas Pohl
Nov 12 '05 #1
0 3580

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Mich | last post by:
I'm going crazy trying to convert an Access Function to SQL. From what I've read, it has to be done as a stored procedure. I'm trying to take a field that is "minutes.seconds" and convert it to...
1
by: James Leech | last post by:
Hi guys I am trying to use an Access function that I found on the web from within an asp page, but I can't seem to correct all the subtle differances between the two languages. When I run a...
0
by: Rigid Kitten | last post by:
I cannot figure out how to: 1. call an Access query from C# and consume the recordset 2. call an Access function from C# and consume the returned value Thank you for your help, John
0
by: Tony | last post by:
Hello everyone, I was wondering is there any way to use/call the "Get External Data" function in MS access via a C# Windows Application? Thanks, Tony
0
by: Amit | last post by:
Hi All, I have to use Access DoCmd.TransferText function of access in my C# code. For it I am taking the reference of Microsoft.Office.Interop.Access dll. But I am not getting Access class ie...
2
by: k-man | last post by:
Hi: I have an MS Access query for a table called MyTable. One of my fields in the query is a custom field that looks like "MyField: = MyFunction(ID)" where ID is a field in MyTable. I have...
2
by: sylver | last post by:
Hi, Following the discussion that can be found here:...
0
by: jcmoncayo | last post by:
New to functions. Found the outlook function in search to add tracking to email from Access to Outlook. Figured syntax for field from form. Issue form can have anywhere from 1 record to multiple...
14
by: frogsteaks | last post by:
Is there a way to get rid of that horrid 'ribbon' and go back to a 'normal' menu structure in '07? I'd like to continue to develop and distribute databases (preferrably with the access run time)...
10
by: prakashwadhwani | last post by:
Office 2007 & thus Access has had it's menus replaced with the Ribbon Bar. It's very disconcerting. In Word, Excel, Access, I feel totally lost. Also all the shortcut Menu pulldowns don't work...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.