Search results for query: *

as long as it is unique across the board you shouldn't have any problems importing it. Now if you have let Access decide what the field types should be for the import then you will have a problem. Access will have looked at your 1999-2004 data and decided that the field should be a number and...

Like you had speculated, Mr. Rhodes, my primary key is not so unique. Typically, the problem is that in making the spreadsheet, at the end of one box to the beginning of the next box it goes: 2070123 | box 1 | smith | bob 2070124 | box 1 | johnson | edward | Box 2| 2071215 | box 2 |...

Thank you Leslie

Thanks, again, for your help Mr. Rhodes. Could you forsee it to be a potential problem that over the years the format of this unique identifier in the fourth column has changed in format. it could look 2 ways for the most part 2005-present - D1DC0512345 1999-2004 - 1032345 I have not tried...

Haha, You did lose me, in many ways, but now I am back from vacation. I am going to work on building fundamental goals and intuitive design for the table starting Monday and get back with you all for more suggestions. I am somewhat startled at the volume of help I have received, and very...

So I am beginning to learn.. There is just too much data for it to run on Excel, or I would be happy to keep it there and just use ctrl+f Thank you for all your helpful comments. Mitchell

Hi, As you can see I am new to the tek-tips community. I am currently working on a project at work where I must converge 6 spreadsheets with 4 columns of information (1 unique identifier) and about 20,000 rows a piece into one easy to navagate and search database. I cannot simply paste these...