Data Updating queries

  • Thread starter Thread starter The Last Mimsy
  • Start date Start date
T

The Last Mimsy

Hi guys,

Access Novice here...

I have a 30MB database that is so large that it is spread across three
workbook tabs (120k records plus by 20 cells wide).

I did two things. I split the spread sheet up into ID field and unique
data, then use another tab (page) for another data set of the sheet.
Similar to relation database table structuring.

I get the whole thing onto a single sheet this way (20 page tabs wide).

Ok, now my database is several months old. I just DLd the new sheet.

I want to construct a series of queries in access that will update any
records that have changed data, and add any new records, but I have had
fairly poor luck constructing queries in access due to my unfamiliarity
with it. My last database authoring session was back in the Borland
Paradox days.

Is there a simple query against a sheet with many cells width that I
can use to update a series of pages that carry only two cells, as in an
ID field and a data field?

Would it be better to run my query for the new record add, and another
query to update the changed records?
 
You might want to ask your question in an Access newsgroup. This is an
Excel newsgroup

Tyro
 
You might want to ask your question in an Access newsgroup. This is an
Excel newsgroup
Click to expand...

It is an excell spreadsheet that I want to run access and use a query
to update, but thanks. I figured it would be appropriate for either
group.
 
Back
Top