Imported data into new records

  • Thread starter Thread starter bob
  • Start date Start date
B

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
 
bob said:
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
Click to expand...


Use an append query

may be easier just to link to Excel file rather than import
 
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
 
bob said:
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
Click to expand...

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.
 
Sounds as if the query is missing some joins. Post more details and the SQL
statement that you're trying to use.
 
Back
Top