Recent content by fisher1977

Gosh, i was not able to paste the table, or pic..:( Anyone knows how to do that first? thanks!

Hi, need your help! below is part of my raw data which contain about 2m records. I need to do in Access instead of excel...

Thanks! Here is my number looks like: 1. in column B: 3.2345678 1.235678999 3.45678888 2.356 ...... 12345.6789 2222.23666665 if i want to keep all the decimals to make the accuracy of my analysis, which data type do i need to choose? 2. in column C: 12:12:00 PM 1:57:29 PM 1:57:56 PM...

Thanks for your help Bob, but under "data type" drop down mean, why there is no "number" option? I selected long integer and I lost the decimals:( Have no clue....

Thanks! 1. I tried the a) but the access doesn't allow me to create a new column with number format. I guess it's over the limit? It's really weird! 2. Yeah, i do import from a cvs file. Can you teach me how to write an import spec to import the errant column as a number? I just know some...

Need your help! I have a large spread sheet with about 700000 rows, which is imported from a text file. I need to change data type in some columns from text to number but Access doesn't allow me to do so. It says "not enough memory/space/storage to complete...". I have tried to change the...