Import data
From: Eric (Eric_at_discussions.microsoft.com)
Date: 08/03/04
- Next message: Bob: "Date calculation"
- Previous message: Lance Harston: "Re: renaming database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 08:33:03 -0700
I have a table called cr. Within that table I have the colums c_id,
c_type, first_name, last_name. I need help creating a query that will pull
from an excel file that have the same colum names. This excel file is
automaticaly generated from one of our systems and the c_id will never
change for the record.
So this is what im wanting to do. I need it to look at the xls file and if
there are new records in that xls file it will add those to the table or if
the records have changed it will update the records within the table based
on the c_id. I think this is feasable but I can't seem to get it to work.
And example would be great.
- Next message: Bob: "Date calculation"
- Previous message: Lance Harston: "Re: renaming database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
