Search results

Also I dont understand what a "Foreign Key" is. There doesnt appear to be any info in the help file.

Literally thousands of characteristics. A typical Feature like a diameter can have an average 3 charateristics, The diameter and two coordinates (Like X and Y axis). Get into GD&T and you can add at least two more characteristic minimum. If I have 500 features I can output approximately 1500...

I am working on creating tables. This one scares me. In some cases I have thousands of entries. :eek: Fortunately I have this data formatted in Excel workbooks.

On This Is Spinal Tap To be an expert on a particular subject one should know what he/she is talking about. I am not an expert, I didnt score an A+ on math and I am considered highly intellegent by my peers. Butt, I did stay at a Holidy Inn Express once and on that note, scoring an A+ on...

1. A job can be related to one or many parts of one part number. 2. Yes 3. Yes, each job has a unique value 4. Each piece, and is unique to each piece. Plus is related to a specific job. 5. Yes As for the oroginal text file I attached I have found a better format option for the output that...

The CMM data is tied to the job, serial number and a part number, there can be many pieces for a job and each has a serial number (traceability). I should have defined part and pieces as seperate entities. The critical traceability is: Part Number Serial Number Job Number CMM Data The above...

Importing works fine, looks quite like excel. Now to figure out what to do with the data. I have a worksheet of some ID's (auto numbering) and fields (1 thru 8). What I cant see is how to tie this to a specific Job Number and Serial Number. Traceablity is critical. I need a tutorial. ;)

The Excel idea I have been using all along. ;) As for Access I will try the importing and see what happens. Thank you for your help!

It appears I am stuck with the format at hand. If I save the data as a csv it is the same format. Row 1 Column 1 will have the entire contents of the row in one cell and so on. No different than if you changed the extension of the attached file to "csv".

I see I had "word wrap" on when using NotePad. Now the file reads the same as it does in WordPad, two lines per set of data. "TOLA:x" signifies the start of a data set (where x is a numeric value) and the next "TOLA:x" starts the subsiquent data set, two rows are one data set. This is how...

The CMM program only outputs a text type file but I can import this into excell and do with it what I wish. I currently import the txt (OUT) file into Excel and extract the data I need to populate spread sheets but that is specific to that need. I am attempting to expand the capabilities using...

I do not know how to begin a database based on the data I have, see attached txt file. I had thought I could import the data from a text file but I am not finding an option to do so. Do I have to import into Excel and then to Access? (Excel is easy for me as I know it well including VB.) FYI -...