473,699 Members | 2,401 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to import/map excel table data to access table data?????

Hi.

How do I import while mapping an excel table to an access table please???
I've searched around and all I can find is a software product or code that
does the same thing as the access wizard.....

If I have to write vb code, where is a sample???

Or do I import the excel in to a new spreadsheet and then
write some kind of querey to move the data from that table
to my current production table.. How do I do this?

Seems to me, access would be able to do this???

Thanks, ANY infor would be appreciated.!

Fred

Nov 12 '05 #1
2 15506
"Fred" <fg************ ***@yahoo.com> wrote in message news:<bn******* *****@ID-76446.news.uni-berlin.de>...
Hi.

How do I import while mapping an excel table to an access table please???
I've searched around and all I can find is a software product or code that
does the same thing as the access wizard.....

If I have to write vb code, where is a sample???

Or do I import the excel in to a new spreadsheet and then
write some kind of querey to move the data from that table
to my current production table.. How do I do this?

Seems to me, access would be able to do this???

Thanks, ANY infor would be appreciated.!

Fred

Any reason you can't create an import specification and then just use it?
Nov 12 '05 #2
Hi.

Thanks for some info. I soved the problem!!!!! After much searching all over
the net, but finally used
Balters's Access 2000 Dev book. Wow.

The problem was to load a current 'Client' table from an excel spreadsheet.
The 'Client' table also has several many-to-one relationships to several
other tables that further define a client. Some examples... Address State
Abbrevs, Client Status, Contact Type.

So there were two issues...
1.) How to map the data field by field from the excel to the current Client
Table.
2.) How to map using relationships to store the table pointers for the
relationship. i.e pointer to the state table for state abbrev in address
using the 2 letter state code stored on the excel spreadsheet.

I did the "get external data' of the excel spreadsheet to create a WORK
Client Table which will be temporary.

I used 'create query in design mode' and (THIS IS IMPORTANT) selected the
the State table, the Client Status Table, Contact Type and the WORK Client
table . All of these are for the input side of the query. I then dragged
the state, status and client type data fields from the WORK client table to
the other tables to establish there relationships. This does the lookups to
get the correct ID's.

I then selected from the top toolbar, Query, Append Query and selected the
Clients Table which this data will get appended to. This creates an append
query.

I then draged the fields down to the lower grid and selected the matching
fields in the 'Append To'. For the relationship tables, I dragged the ID's
(or pointers) and not the data.

(A side note,, on some 'not required fields' on the client table, I had to
set 0 length okay.)

I ran the query and it worked. It set the correct pointers for all the
relationship tables too.

Fred

"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com...
"Fred" <fg************ ***@yahoo.com> wrote in message

news:<bn******* *****@ID-76446.news.uni-berlin.de>...
Hi.

How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access wizard.....

If I have to write vb code, where is a sample???

Or do I import the excel in to a new spreadsheet and then
write some kind of querey to move the data from that table
to my current production table.. How do I do this?

Seems to me, access would be able to do this???

Thanks, ANY infor would be appreciated.!

Fred

Any reason you can't create an import specification and then just use it?

Nov 12 '05 #3

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

Similar topics

1
6483
by: Fred | last post by:
Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access wizard..... If I have to write vb code, where is a sample??? Or do I import the excel in to a new spreadsheet and then write some kind of querey to move the data from that table
5
11593
by: Johnny Meredith | last post by:
I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can correct once the data is in Access (or during the import process itself). Furthermore, the text files are poorly set up, such that some records may be "shifted" over a few characters, and therefore the fixed width nature of the file is corrupted. ...
4
3021
by: Steve Jorgensen | last post by:
I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not coming to a firm conclusion over whether it was the better approach, and wonder if I should do it differently the next time I'm faced with a similar issue. I needed an app to automatically import from spreadsheets with a semi-dynamic structure,...
1
2474
by: John Hewitt | last post by:
A 'newbie' question - importing into Access from Excel. Googled the group postings but I can't find the amswer I have a 50 line three column file in Excel that contains Names and Tel numbers. Each column is named to agree with the Access database. Read the instructions "Import Excel files into an Access database". Followed them to the letter. Everything goes well until the final Wizard action is clicked "Import to table 'PHONEDIR'.
3
3712
by: deko | last post by:
I've been trying to use the Access Import Wizard to expedite importing data into my mdb. The nice thing about the wizard is that I can import from different file formats - txt, xls, even Outlook - and dump everything into a table. The problem is once I have the data imported into a new table, I can't do much with it. If I try to run an Append query and insert data from the new table into an existing table, the query fails - "Error...
15
4211
by: daniroy | last post by:
Hello everybody, your help will be very very welcome on a very classic question... I have some Excell Macro background, a little bit of VBA knowledge. I import daily from Internet series of data. They are setup as follow, with a few more columns on the rights as stock prices, dividend and so on as: Date Code Country Adjust Reason Name Shares 25/02/2005 FR0000045072 FR CREDIT AGRICOLE
11
5383
by: MD | last post by:
Hello, I need to import a sheet of 884 different excel-file with same lay- out. The sheet name is 'Totaal' and is the same in all different files. Is there a script (module) in order to: 1. create a table with all the different names of the 884 files 2. create the import queryfor the 884 different files, but also mentioning the file name of the excel-file in a colomn
4
1962
by: Earl Anderson | last post by:
I guess I missed the boat on the logic for this one. Immediately upon hitting "Import" in an attempt to import an Excel file containing 7 columns of 'txt' formatted data into AXP, I got a "Type mismatch" error. A search of previous posts indicated that Access did not 'like' most data types being imported except for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work either, receiving the same "mismatch" error message. ...
6
26324
by: provor | last post by:
Hello, I have the following code that I am using when a user presses a button to import an excel file into a table. The code is hard coded to point to the correct table. This works great for this one table. My problem is I have two buttons I want to use this code for for the two buttons would put the data in different tables. I have tried copying and changing a few things and nothing will work for me. The code is set up in a module and then I...
0
8703
marktang
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...
0
9185
Oralloy
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...
1
8935
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,...
0
7773
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, 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...
1
6540
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 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...
0
5879
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();...
0
4389
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...
2
2359
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2015
bsmnconsultancy
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...

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.