473,480 Members | 1,726 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Access only insert/update part of my Excel file data

1 New Member
hi,

i have a system with microsoft Excel 2007 and Access 2010.

When i try to import data using Access VBA the debugging result said it is success.

However when i review back the database only 20 data inserted out of 134 rows of data.

My table use Indexes of Primary key(Text) and InternalID(Autonumber).

Could you please help me on this.
Apr 25 '13 #1
1 1337
Rabbit
12,516 Recognized Expert Moderator MVP
It would help to see the code.
Apr 25 '13 #2

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

Similar topics

1
2592
by: Ken | last post by:
Help! I have a MS Access database made up of a single table. The data updates for this database comes in the form of a single Excel spreadsheet, which is imported into the database table. I...
1
1795
by: Napo | last post by:
Hi I use a c# method to open an excel file and to read it's data.But i find a problem that if i changed the excel file data manually by using excelapplication,the readed data by c# method isn't...
2
12698
by: Sreedhar Vankayala | last post by:
Hi, I joined a project where we need to import data from a excel file into sql server via the asp.net. After doing a long research found that #1. Upload Excel file to the server #2. Load or...
2
1349
by: Phoebe | last post by:
Hi, Good Day! Currently I have a few excel file storing different range of data. For eg. 1-100 in FileA; 101-200 in FileB; 201-300 in FileC...total 10 file. I'd like to save these set of data to...
3
1802
by: Miguel Ramirez | last post by:
Hello all, Is there any way to import an excel file data from user's computer? I want to read all records in the excel file and write the data in a SQL server table. Any help will be really...
3
2853
by: eee | last post by:
Hi, I have an excel file and would like to update a column in a table in my database. How do I import the data from the excel file? does anyone know how I can do this? :)
1
3480
by: pappu | last post by:
Hi friends, I m just stuck with extracting excel file data into text file. So can any body please help me out. thx, Sachin.
1
2164
by: psuaudi | last post by:
I’m using a vb.net app that opens a powerpoint presentation and calls the updatelinks function of powerpoint. One slide in the presentation is linked to a cell range in an excel file, and the...
1
3344
by: viki123 | last post by:
I have excel file i want to insert it into sql using asp and not using sql server
0
1359
by: NareshN | last post by:
Hi All, I have this tables.I want to upload excel file data to multiple tables. Excel file consist of EmpName,1 week dates with data(TimeIn and TimeOut). I want to insert EmpName into...
0
7041
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
6908
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
5331
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,...
1
4772
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...
0
2994
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...
0
2980
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1299
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 ...
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
178
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...

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.