|
Posted by --CELKO-- on 01/31/08 23:22
>> There are hundreds of clients in this data base that have to be kept and maintained. My question is: Will auto numbering work with this imported file and will it continue with the last number that is in there and if not can I make it work and how? <<
Neither ACCESS nor Spreadsheets are databases. You might want to
actually do it right when you move to SQL. That would mean
normalizing your data, setting up a data dictionary, doing some data
scrubbing, etc. Auto-numbering is totally non-relational and would
have to be replaced with a real key in an RDBMS.
This is not easy and you are probably going to discover that you have
redundant and conflicting data for the same entity under different
auto-numbers. Then you will find orphaned rows where you tired to use
the auto-number like a pointer chain.
Navigation:
[Reply to this message]
|