moving data from excel to Access

[Ferret01]

I am new to Access 2003, and have run into an issue. I am using Access to
create a database for ArcMap. Simply i need to copy/import a column from
Excel and paste the data into a database i already have. The only way i have
found so far is simply adding in the data one row at a time, which wouldn't
be an issue, except that there a few thousand entries (about 5000) that i
need to put in this column. I would use Excel for the whole database except
that Excel only allows 65000 rows and i have a little over 85000 parcels. Is
there a way to enter all of these parcels into my current .dbf file?

 

[karl dewey]

Is there a way to enter all of these parcels into my current .dbf file?
Do you have Access or either DbASE or FoxPro?

You can import the Excel into Access and then run an update query. The hard
part is making sure that row 14 of imported data actually belongs with record
15 of your Access table.

 

[Ferret01]

The hard

part is making sure that row 14 of imported data actually belongs with record
15 of your Access table.

See I do not need to sync up any data, the column i need to import can go to
the bottom of the proper column, basically its a list of Assessor Parcel
Numbers that I need to add to another list of Parcel numbers. All other data
will be added later such as zones. Would the import and update query work
for this? Also, again I am new to most of this so what would the query look
like?

 

[dhstein]

Here's another idea which may be easier.

Access allows you to read data from an external source such as an excel
file. First make a backup of your database - or make a copy of your table.
Then set up your Excel file with headings identical to the headings in your
access database. Then put your column of data in whichever column you need
and then in Access import the excel file specifying the option to append
records to an existing table - specify your table. I use Access 2007, so I'm
not sure exactly what your selection looks like.

 

[Ferret01]

dhstein, Thank you that did exactly what i wanted, i appreciate your help.
Karl Dewey, thank you as well.