Hallo,
Graag hulp, want ik heb zelf geen oplossing
Al gegoogeld, doch zonder concreet resultaat
Op onze webserver (intranet) hebben we een website draaien
Een bepaalde ASP-pagina haalt zijn data uit een MDB
De mdb wordt gevoed door andere asp-pagina's
Tot hier geen probleem
Doch wegens een keuze van anderen (is niet meer te wijzigen), zal er nu ook
een XLS dagelijks worden geleverd
De kolomhoofden in de XLS zijn identiek als bij de MDB
De data in de XLS zou moeten ingelezen worden en in de MDB moeten terecht
komen (via variabelen ?)
De hoeveelheid lijnen (de records dus) in de XLS kan dagelijks verschillen
(de ene keer 350, de andere keer 420, m.a.w. steeds een ander aantal)
De XLS heeft steeds dezelfde naam en staat steeds in hetzelfde pad
Nog een bijkomend probleem (?) is het feit dat indien alle records steeds
worden bijgevoegd in de mdb, dat er dan veel dubbele records zullen zijn,
vermits die dagelijkse xls veel records bevat die de dag voordien er ook
reeds instonden
Ik dacht aan het volgende: Voordat de rijen uit de xls in de mdb te
plaatsen, de bestaande records in de mdb (van de vorige xls) te verwijderen
en dan pas die uit de nieuwe xls toe te voegen.
Wie kan en wil me helpen
Is redelijk belangrijk
Indien nog meer info gewenst, zeg maar
Serge H.
1  2002 
"Charlotte" <ch************ ***@SPAMtelenet .bewrote in message
news:Gj******** ***********@new sfe29.ams2...
>
Hallo,
Graag hulp, want ik heb zelf geen oplossing
Al gegoogeld, doch zonder concreet resultaat
Op onze webserver (intranet) hebben we een website draaien
Een bepaalde ASP-pagina haalt zijn data uit een MDB
De mdb wordt gevoed door andere asp-pagina's
Tot hier geen probleem
Doch wegens een keuze van anderen (is niet meer te wijzigen), zal er nu
ook
een XLS dagelijks worden geleverd
De kolomhoofden in de XLS zijn identiek als bij de MDB
De data in de XLS zou moeten ingelezen worden en in de MDB moeten terecht
komen (via variabelen ?)
De hoeveelheid lijnen (de records dus) in de XLS kan dagelijks verschillen
(de ene keer 350, de andere keer 420, m.a.w. steeds een ander aantal)
De XLS heeft steeds dezelfde naam en staat steeds in hetzelfde pad
Nog een bijkomend probleem (?) is het feit dat indien alle records steeds
worden bijgevoegd in de mdb, dat er dan veel dubbele records zullen zijn,
vermits die dagelijkse xls veel records bevat die de dag voordien er ook
reeds instonden
Ik dacht aan het volgende: Voordat de rijen uit de xls in de mdb te
plaatsen, de bestaande records in de mdb (van de vorige xls) te
verwijderen
en dan pas die uit de nieuwe xls toe te voegen.
Wie kan en wil me helpen
Is redelijk belangrijk
Indien nog meer info gewenst, zeg maar
Serge H.
I'm not sure whether there is much point in replying in English, but here
goes anyway. According to Google's translator, you want to be able to
update your Access database with records from an Excel sheet. Some of these
records may already exist in the database. You want to avoid creating
duplicates.
I would read the contents of the Excel sheet into a spare table in the
database, then use the Access Query Wizard to create a Find Unmatched query
on the spare table to find records that don't match existing ones. That
will form the basis of an Insert statement, as those are the records you
want to insert. The slowest part of the process will be reading the Excel
sheet into the spare table, but that can be done using the Jet OleDb
provider.
--
Mike Brind
Microsoft MVP - ASP/ASP.NET This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: teso |
last post by:
Hallo Zusammen,
Ich suche eine Möglichkeit Internet bzw. HTML Inhalte zu vergleichen.
Mein Ansatz war den hashcode (URL.hashCode()) einer URL zu ermitteln
und diesen zu vergleichen.
Dazu habe ich eine Testseite angelegt und den Inhalt der Seite
verändert.
Doch leider kommt auch bei ungleichen Inhalten der HTML Seite der
gleiche Hashwert raus.
Z.b. habe ich Bilder hinzugefügt und wieder gelöscht.
|
by: tom |
last post by:
I am new to SQL administration.
>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.
Basically I want to say:
If fk_ID is in list then
do these statements to that record
|
by: CSDunn |
last post by:
Hello,
I have an Access 2000 Project in which the data comes from a SQL Server 2000
database, and multiple users need to be able to see new records as each user
adds records. The users also need to be aware of updates as they are made to
current records. The data the users are looking at is presented in a subform
that has the Default View property set to 'Single Form'.
In order for each user to see the update to the current record as...
|
by: Paul T. Rong |
last post by:
Dear all,
Here is my problem:
There is a table "products" in my access database, since some of the
products are out of date and stopped manufacture, I would like to delete
those PRODUCTS from the table, but I was not allowed to do that, because
"there are records related with those PRODUCTS in other tables (e.g. in
table "ORDER_DETAIL").
|
by: Grant |
last post by:
Hi
Is there a way to recover deleted records from a table. A mass deletion has
occurred and Access has been closed since it happened
Louis
| | |
by: Jan |
last post by:
Hi
I have a database that I use to keep track of the sales promotions that we
send to companies.
I normally send a mailing based on a subset of the companies in the database
(found using the query: QryICTMassDistribution3) , I then use a form and
the code below to create a new record in the corrispondence table to show
what corrispondence has been sent to various companies.
|
by: KC |
last post by:
Hello,
I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB.
I have tweaked this DB to work for our small co. It has worked pretty
well up until I made the mistake of deleting about 80 records from the
Orders table. 80 out of a 1000 records.
Now our data entry form shows our customer addresses, but not customer
order history. When looking at all of the tables, customer, payments,
orders, they still have all of the...
|
by: LetMeDoIt |
last post by:
Greetings,
I'm using ASP to retrieve from MSSQL and I then populate a table.
After several months of successfull retrieves, this same code now
bombs out. It turns out that if I clear out from SQL about 10,000
records, the retrieve is then successfull.
Reading some of the posts, I believe I need to set the cache. If
anyone can point out where that cache, it would be greatly
appreciated...
|
by: shriil |
last post by:
Hi
I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night) and the 'employee
name'. There is another table which assigns an ID to the Shifts, i.e.
1,2 and 3 for morn, eve & night shifts respectively. From the mother
table, the incentive is calculated datewise for each employee as per
his shift duty. In...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
