473,497 Members | 2,051 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HOWTO: Import data from XLS into Access Table containg AutoNumbers

12 New Member
Hi,

I am attempting to append data to an existing table in a database. What I did was create a report containing all the fields, then used analyze in Excel. I used these field headings to create another XLS file with the new data I would like to append. The database that I am attempting to append contains an autonumber field, which is the table's primary key. In my error log the message reads:

Error
Null value in an auto-number field


What's happening? Is there a better way to do this?

Thanks
- Tony
Oct 4 '07 #1
1 1789
FishVal
2,653 Recognized Expert Specialist
Hi, Tony.

Clarify the way you append records to the table.
Oct 6 '07 #2

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

Similar topics

4
3825
by: Logan | last post by:
Several people asked me for the following HOWTO, so I decided to post it here (though it is still very 'alpha' and might contain many (?) mistakes; didn't test what I wrote, but wrote it - more or...
3
6259
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...
3
9574
by: kylei | last post by:
When I try to append one table to another with the exact same field names I get an error... Microsoft Access was unable to append all the data to the table. The contents of fields in 0...
9
1907
by: Hi5 | last post by:
Hi, I have designed a databasewhich is now able to store all data from my client's Excel sheet.Now I am looking for a good way to move their data into this Db. If I want to do this myself will...
17
2034
by: Wilfried | last post by:
Hi, I have 5 tables: main data1
11
4467
by: Alan Mailer | last post by:
A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...
9
2007
by: Killer42 | last post by:
Hi all. Thought I'd share a recent experience with you, as a cautionary tale. I have a reasonably large-ish database (around 400MB) holding a single table. One of the fields is a pointer to a...
1
1687
by: Julie Smith | last post by:
Hi, I have a question about autonumbers in Access db. How are they assigned when adding a new row to a table? I have table that has an autonumber column (replication ID/System.Guid) and a name...
4
1937
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...
0
7121
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,...
0
7162
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
7197
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
7375
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
3088
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
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1411
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
650
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
287
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.