Hello everybody.
Somebody has given me nine files with some data
for the years 1997, 1998, ... , 2005. They are 9 different
mdb files. Each one has many tables, forms, and other things.
But all of them have a table called EAL, with fields like year
(this year contains, for all the registers, the year corresponding
the one indicated by the file name), name, surname, country and much
more fields.
The person who has given me the files wants a new mdb file with
a table that should contain all the registers from all the 9 files, in
only that table, only one table, in a single mdb file, and without
the fields that we are not interested in.
How can I combine some fields of one table in every .mdb file
in a single table in a single .mdb file?
Thanks in advance,
S.
1  5308 
Use a series of append queries on linked tables. there are other ways,
but since this is a one-off, just open the final mdb and attach the
tables and then create and run your append queries.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Steve Jorgensen |
last post by:
Hi all,
I'm working on the schema for a database that must represent data about stock
& bond funds over time. My connundrum is that, for any of several dimension
fields, including the fund name itself, the dimension may be represented in
different ways over time, and may split or combine from one period to the
next.
When querying from the database for an arbitrary time period, I need the data
to be rolled up to the smallest extent...
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I have two tables with 5000 entries on them. One is based for regular time
with several variables example (employee name, date,time in and out, code,
customer, building) I have another table that works with overtime but has
the same feilds within the table. I want to be able to run a report that
combines the regular time and overtime for the warehouse and seperated by
each customer. I have tried join tables but I keep ending with, (if it...
|
by: Reidar Jorgensen |
last post by:
I have several Access databases, identical in structure, but different data. Is there an
easy way to combine them all into one database? There are six tables, I just want the
data from all databases merged into one database.
Thanks in advance.
|
by: PZWU |
last post by:
How can I build a big XML file by appending a few smaller
xml files in C#?
Below is what I've been trying:
/* FileString.xml is the path and name string of the big
xml file*/
XmlTextWriter writer = new XmlTextWriter (FileString,
System.Text.Encoding.UTF8);
writer.WriteStartDocument();
writer.WriteStartElement("FundXML");
|
by: amy |
last post by:
Hi, all:
> i am a new end user of access, now I have many excel files need to
> import to One table in access (combine all excel files into one table
> in excel). In excel files, some columns will have both # and text in
> the same column. The coloumn names in each excel file are mostly same
> but still a lot of different names(items). I was told to set up import
> specification, but how? i am not a programer or not access
> professional,...
| | |
by: rdemyan via AccessMonster.com |
last post by:
My App has 10 or so tables that we provide that contains proprietary data.
This data will need to be updated once or twice a year.
I would like some comments, suggestions on my proposed strategy for updating
these tables via an ftp site:
1) Post a .mdb file to our ftp web site that contains the updated tables. My
App code connects to the ftp site and gets the file name for any update files
on the site. I already have code to do this...
|
by: nugz |
last post by:
I want to combine 3 tables with like data then append it with a filter.
Tables: NewStarts, Complaints, Memos
Combine: Date, Address, Route, Pub, etc....
Then sort: previous 8 days, pub/freq for that day etc...
I can already do the append filter, but I cant combine and then append.
I tried a Union and did the combine.. but lack the part to append the union.
|
by: Rodjk #613 |
last post by:
Hello,
I am working with a database that is in use in several locations.
The structure of the databases are identical, but the data is
different.
I am tasked with combining the data into one large database.
(It is SQL 2000)
I have .bak files for each location.
Is there any way to restore a backup into a database, combining the
data?
|
by: bluereign |
last post by:
Thank you for your assistance. I am a novice looking to JOIN and append or combine records from 2 current Tables into 2 new Tables named below. I have been able to JOIN Tables with the script below. My problem is if I don’t use the WHERE clause in my script below, the script can query up to 3 records with the same “LoanNo” due to the fact that there can be up to 3 “TypeCodes” in each Table (Borrower, Co-Borrower 1 and Co-Borrower 2...
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |
