RE: Import Data from Csv AND set relationships

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave

Thanks for the update and I think I have the jist of what you are suggesting
I do, however for the dim and slow of thinking (Im Scottish) can you please
confirm:

I create the Table as Normal using the Import Mechanism within Access and
then use the TableAnalyser to set the relationships ?
I then create a link to the external data (updated table) ?
I then remove the data within the table and write an append query to update
the information from the linked information ?

And this will automatically update all the links ??

As an aside I have two columns in my table one called 'Home Office' and
another called 'Current Office' as staff can be transferred regularily. Both
these columns contain the same data set. Can I have both colums relating to
the same data set ??

--
Thank you for your time and all your help

Regards
Alan


"Klatuu" wrote:

If I understand correctly, you were pretty much on the right tract. I would
suggest you create the table and establish the relationships. The if you
need to import into this table, link to the external data rather than import
it, then use either/and/or an append and an update query to move the data
from the linked table to the Access table. Then just drop the link. You do
that with the DeleteObject method.
--
Dave Hargis, Microsoft Access MVP


"Alan" wrote:

Hello All

I have a database that imports details of employees on a daily basis. These
employees share a number of repetitive and Common attributes such as OFFICE /
DEPT / GRADE and afew others. This table is not unique as I have a number of
other tables that have similar fields

I have run for some time by deleting the contents of the table and updating
the employee information daily, however as I try to learn more have thought
about making the database relational and creating releations to the aspects
above.

Can someone point me in the direction for the code that is required to
reinfore and update the references ... the acImport aspect is relatively
straight forward ... however I am not to sure about creating the
relationships, initially performed throught the Table Analyzer (Table aspects
selected by myself)

If this is a daft idea, please tell me and I can probably live what I have,
although everything I read suggests this other option is a tidier way to
manage the data

Many thanks for your help in advance
--

Alan
.

Relevant Pages

  • Re: find all employees whose total salaries equal a given amount
    ... I followed your advice with a small data set and it did work, ... adjustable cells". ... "Peo Sjoblom" wrote: ... Because the dataset here is not huge, I see that those employees are Paul ...
    (microsoft.public.excel.misc)
  • Manage append query key violations?
    ... I have a database where the user can add employees to a course list. ... employees are added to a table with an append query. ... which will result in an "append query key violation" which I would like ... code reaches the error handler, so even tho I've put something in the error ...
    (microsoft.public.access.queries)
  • RE: Add New Field to DB
    ... Do not some employees require more than one type of training class? ... > Can you at sometime in the future return to using a single field even though ... > you have two number schemes? ... >>> For a new hire I ran an append query that added all training marked as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Automatically adding a new record
    ... scubadiver wrote: ... When I run the append query, it adds records only to the permanent employees. ...
    (microsoft.public.access.macros)
  • Re: Update Query w/ Unmatched Records
    ... not append all the employees - it will add the employees you don't have and ... General Office. ... way to get it to also update my table to include the new employee record? ... append query would try to re-create all 900 employees. ...
    (microsoft.public.access.queries)