We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a
complete table from another Access database.
How can I import the data from table 1 of one file into various tables in
the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)
FileOne.MDB --------
Table1
Name C20
Address C30
Table2
City C20
Phone C15
FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15
Table2
Address C30
City C20
Postal C10
Thx! 6 7346
Link to the tables in database1 and use a series of append queries on each table
to move the selected data in each table to the appropriate table in database2.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Noozer" <do*******@me.h ere> wrote in message
news:D9PNc.1312 64$ek5.9195@pd7 tw2no... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables in the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
The database application has a function called an "insert query" which will
do exactly what you want in one step. I am new to Access so I don't know if
Access has the same type of query. If not, someone with Paradox can do it
for you and return the data as MS Access tables.
"Noozer" <do*******@me.h ere> wrote in message
news:D9PNc.1312 64$ek5.9195@pd7 tw2no... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables in the second file?
e.g. Move the like data from the tables in FileOne to the tables in
FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
> The database application
I meant the database application called Paradox. has a function called an "insert query" which will do exactly what you want in one step. I am new to Access so I don't know
if Access has the same type of query. If not, someone with Paradox can do it for you and return the data as MS Access tables.
"Noozer" <do*******@me.h ere> wrote in message news:D9PNc.1312 64$ek5.9195@pd7 tw2no... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables.
The table structure of each table is completely different from each other,
but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables
in the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
What about creating a make table query in the old database to the new database??
"Noozer" <do*******@me.h ere> wrote in message news:<D9PNc.131 264$ek5.9195@pd 7tw2no>... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables in the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
Sorry, an append query not a make table query. You may need to create
a link to the old database to the new database to do the append query.
Once it's done delete the query and the link and you should be set.
Lynn
"Noozer" <do*******@me.h ere> wrote in message news:<D9PNc.131 264$ek5.9195@pd 7tw2no>... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables in the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
"Noozer" <do*******@me.h ere> wrote in message news:<D9PNc.131 264$ek5.9195@pd 7tw2no>... We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.
From what I see in the MS Access help I can only find how to import a complete table from another Access database.
How can I import the data from table 1 of one file into various tables in the second file?
e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)
FileOne.MDB -------- Table1 Name C20 Address C30
Table2 City C20 Phone C15
FileTwo.MDB -------- Table1 Name C20 LandPhone C15 <--data from Phone field in FileONe CellPhone C15
Table2 Address C30 City C20 Postal C10
Thx!
You can temporarily attach the tables, write a bunch of append queries
with the correct criteria (start with a select query first!) and then
run those. Once that's done, you don't need the attached tables
anymore and you can delete them. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Doug Baroter |
last post by:
Hi,
One of my clients has the following situation. They use Access DB for
data update etc. some business functions while they also want to view
the Access data quickly and more efficiently in SQL Server 2000. Huge
Access db with over 100 user tables, over 60 MB data.
The DTS package that comes with SQL Server 2000 seems pretty "messy"
in the sense that it assumes that one needs to do one time import only
or accurately it does not...
|
by: steve |
last post by:
Hi,
When I copy tables in a database from one server to another using
enterprise manager, everything copies ok, except for field defaults.
Has anyone seen this, and what is the solution?
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL:...
|
by: Kajol |
last post by:
Hi All,
can u plz tell me how to import data from mysql to another database.
& how to export data from anotherdata base to mysql
Thanx for ur Advice
Regards
Kajol
|
by: Jon Ole Hedne |
last post by:
My Access 2002-application need to work with tables from both Oracle and
Access. To solve this, I want to run some querys on three views in Oracle
and import the results into temporary Access-tables.
I have tried this:
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database
Password="
conn.Open datafil
|
by: Dave |
last post by:
We just shifted to Access 2003 at work.
I have a database that contains information that is updated each month with
another (source) Access file.
To update the fields in our database, I built (and used fine up till now) a
number of queries that copy the appropriate field contents and update the
fields in our database. This is done using a Unique_ID number common to
both.
| |
by: strauss.sean |
last post by:
Hi! I am trying to import a query as a table from a MS
Access database in a specified drive, path, and filename; my filenames
and paths are being stored in a table for easy reconfiguration.
Anybody done this before? Please let me know! Thanks, Sean
BTW: I have learned that if I wanted to import a table, this is how
it's done:
DoCmd.TransferDatabase acImport, "microsoft access",
"C:\Folder\file.mdb", acTable, "sourcetable",...
|
by: David Berry |
last post by:
Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the user has the ability to upload a file (.txt or .csv). The data in the file may be comma delaminated, tab delaminated, fixed width etc (we don't know).
What I'd like to create is something like MS Access uses to import an Excel file into the...
|
by: Randy |
last post by:
Folks:
We have a web-based app that's _really_ slowing down because multiple
clients are writing their own private data into a single, central
database. I guess the previous programmer did things this way because it
made things easy. Well, I'm the person that has to put up with
the long-term headache.
Anywho, someone at work wants things sped up, so what I'm looking
at doing is this for each client:
|
by: tezza98 |
last post by:
I need some help.
Im using a dtsrun command to import 9 tables into an Access database, most of the tables have about 1000 rows, but one has 20000+ rows and grows everyday. Im Using Access 2003 and SQL Server 2000. on a WinXP Machine
When the database is opened a stored procedure drops all the tables and then imports the csv files using dtsrun. The database is only used for reporting and the data is entered into the csv files using 3rd...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
| |