Imported data into new records

[bob]

Hi, I regularly receive new cases from my staff which we manually key into
our database. These are sent to us in an Excel format. I can import the
Excel data into an Access 2003 table without any problems.



Now how do I transfer this data into the correct tables, which normally hold
this data.

Each row of data would need to be a new record.



Any help, advice on the best way to achieve this would be very much
appreciated.



Thanks,



Bob

 

[Rod]

Hi, I regularly receive new cases from my staff which we manually key into
our database. These are sent to us in an Excel format. I can import the
Excel data into an Access 2003 table without any problems.



Now how do I transfer this data into the correct tables, which normally
hold this data.

Each row of data would need to be a new record.



Any help, advice on the best way to achieve this would be very much
appreciated.



Thanks,



Bob

Use an append query

may be easier just to link to Excel file rather than import

 

[bob]

Rod I have tried that but when I open the query I get 60 or more records
when I am only trying to import say 5 records.

Why is this? And how do I stop this from happening?

Thanks Bob

 

[Rod]

Rod I have tried that but when I open the query I get 60 or more records
when I am only trying to import say 5 records.

Why is this? And how do I stop this from happening?

Thanks Bob

Where are the 60 records coming from? A|re they all in the Excel file and
you only want the recent ones?
Maybe you need to add a criteria to the query to filter out what you don't
want.

 

[Ken Snell]

Sounds as if the query is missing some joins. Post more details and the SQL
statement that you're trying to use.