By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,339 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,339 IT Pros & Developers. It's quick & easy.

Help importing

P: n/a
I export some data from access to excel, then I update the data by
importing it. The way I update the records is relating them with a
unique ID, Is there a way to add a new record ? One without an ID?
thanks

Sep 29 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

Ga************@gmail.com wrote:
I export some data from access to excel, then I update the data by
importing it. The way I update the records is relating them with a
unique ID, Is there a way to add a new record ? One without an ID?
thanks
Why not create an import specification and do not import the ID field?

Sep 29 '06 #2

P: n/a
And how can I update the fields?
pi********@hotmail.com ha escrito:
Ga************@gmail.com wrote:
I export some data from access to excel, then I update the data by
importing it. The way I update the records is relating them with a
unique ID, Is there a way to add a new record ? One without an ID?
thanks

Why not create an import specification and do not import the ID field?
Sep 29 '06 #3

P: n/a

Ga************@gmail.com wrote:
And how can I update the fields?
pi********@hotmail.com ha escrito:
Ga************@gmail.com wrote:
I export some data from access to excel, then I update the data by
importing it. The way I update the records is relating them with a
unique ID, Is there a way to add a new record ? One without an ID?
thanks
Why not create an import specification and do not import the ID field?
If all you are updating are the autonumber fields, the database will do
that for you. IF that's not the case, explain further what you're
trying to do.

Sep 29 '06 #4

P: n/a
Thanks,
The Whole idea is to create a database to export companies data from
Access to excel. Work with it in Excel, mainly update some numbers and
adding new rows. Then I want to import this data in the access and
update the records I already have and add the new records.
I donīt know how to check If the record is new and then update it..
Thanks

Oct 2 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.