473,396 Members | 1,924 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,396 software developers and data experts.

URGENT!!: using access to pull data from an excel file

55
I have an excel file with data.I want to pull data from the excel file into a table in access.The data in excel has products and customers who buy these products and sometimes 1 customer can buy many products.
If i import into access will be able to show this realtionship?
Please guys, this is urgent
Thank for your anticipated responses..
Nov 29 '06 #1
0 1227

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Paul | last post by:
I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...
7
by: Andy Davis | last post by:
I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which...
3
by: jnb0012 | last post by:
Can anyone help with this? Here is the code I am using. The problem is, where it checks if a file exists, it always goes to else. Even if the file is there, it won't open the file, goes straight...
3
by: c676228 | last post by:
Hi everyone, I will develop a program to enroll a group of people on-line. Since we don't have number limitation for the people in the group. I am wondering if there is any company allow people...
2
by: newuser1980 | last post by:
Hey, I am in the process of writing some VBA code that will do the following: 1) Create and send an e-mail using Outlook with an excel file attached. The excel files are present in a specified...
1
by: cckelly | last post by:
I originally posted this problem on the SQL Server forum. I received a reply from a definite non-newbie instructing me to post my question to this Access forum. SO, here goes... ---- Hello, all!...
3
by: CCECIL | last post by:
Hello all, I am new to VBA and I am not very good at it. I have chosen to learn VBA for this simple reason...I can't figure out how to export an Access table into a formatted excel document. ...
6
by: Swapnil Vaidya | last post by:
Hi All, I have got stucked up in one problem from many days. I have one report in Access 97. When I do right click on it and select option "Save As./Export". It gives me Error as "Overflow".....
3
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
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
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...
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,...

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.