Re: best way to update table

You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.

The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.

Re: best way to update table

Jeff Boyce

30 Nov 2009 17:54

You are asking a "how" question ... you've apparently decided the way you
need to accomplish something. You may get more use of the newsgroup and the
experience of folks here if you describe what that something is...

If you create a query that deletes all the records from the table, then
create another query that appends all the (Excel) records into that table,
you have not changed the table structure.

BUT!!! Excel-structured data is rarely well-normalized. So what, you ask?
So Access is a relational database and is optimized to work with
well-normalized data, not 'sheet data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

Signature

Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

> Hi,
>
[quoted text clipped - 10 lines]
> the
> table structure (field lengths, names, etc) in tact?

David3553

30 Nov 2009 17:44

Hi,

I need to update a table every week with information I download from our
financial systems. I need to delete the old data and replace it with newly
downloaded data; because I need to capture changes to records, I can't just
append the current week's data to my table. I download the data to an Excel
file then I import the Excel file into my access table, replacing the
existing table.

What's the best way to refresh all of the data in my table while keeping the
table structure (field lengths, names, etc) in tact?

Quick links: