can't add records to table

[terry freedman]

Hi

I have a database of subscribers to a newsletter, and wish to add a
batch of names manualy. I am coming up against these problems:

1. When I import the data from an excel spreadsheet, I don't get the
option to add the extra names to the existing table -- I have to
create a new table instead, for some reason. I can't find a way of
merging the two tables to crate just one (ie the original).

2. I hit upon the idea of deleting the table, having first cied all
the existing names to the excel spreadsheet. Then wen I imported the
data, I created a new table with the original table's name. That
seemed to work fine, except that when I looked I saw that only column
3, out of 3 columns of data, had actually been imported.

Any help/advice would be much appreciated.

TIA

Terry
==
Terry Freedman
www.ictineducation.org

 

[DDM]

Terry, does the first row in your Excel spreadsheet contain column names? If
it doesn't, that may be why you don't get the option to add the data to an
existing table. You might want to modify the design of your Excel
spreadsheet to add column names (and make the column names correspond to the
field names in your Access table). That would take care of the problem right
there.

If you still can't append the records to an Access table when you import
them, then just create an append query to append the records from the
imported table to the original one. Save the query. Then, every time you
import a batch of names from Excel, import them to a table that has the same
name as the one referenced in the query (Access will prompt you to confirm
that you want to overwrite), then run the append query.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Marin Kostov]

File - Get External data Import - and you select the Excel spreadsheet file
type, then you follow the screen tips, and then there is a choice "where
would you like to store your data" (how polite - click in an existing
table, find your table and click Finish.
If there are problems, search the Help for Troubleshoot importing and
linking.