O
obrady
I have a very large database that, due to a text import bug, I have to
reformat each time I import data. (the issue is the time field, I've posted
before with no responses)
What I need to know now is if there is a rule of thumb as how much RAM you
need to change the data type of a field.
I have over 20,000 records and I have to go into a Date/Time filed, change
it to text, then back to Date/Time (some of the queries require the time
field to be in Date/Time format not text to run properly).. I can change it
to text, no problem, but it has reached the point where it can't change back
and gives an out of memery error message. Since I have more than 3/4 of my
hard drive available I assume it has to be RAM, I have 256mg.
If you want to add a comment about the import issue here goes: I obtain the
data from a sytem in a text delimted format. I import the data into the
database and for some reason, about every 3rd or 4th time entery imports in a
format different from the rest. Instead of 13:30, for example, it changes it
to 1:30 PM. Try ir=t on your computer and see if it happens to you. Just
create a database with time as your only field, then create a spreadsheet
with a colum of times, save it as a text file and then import it and see what
happens to you.
reformat each time I import data. (the issue is the time field, I've posted
before with no responses)
What I need to know now is if there is a rule of thumb as how much RAM you
need to change the data type of a field.
I have over 20,000 records and I have to go into a Date/Time filed, change
it to text, then back to Date/Time (some of the queries require the time
field to be in Date/Time format not text to run properly).. I can change it
to text, no problem, but it has reached the point where it can't change back
and gives an out of memery error message. Since I have more than 3/4 of my
hard drive available I assume it has to be RAM, I have 256mg.
If you want to add a comment about the import issue here goes: I obtain the
data from a sytem in a text delimted format. I import the data into the
database and for some reason, about every 3rd or 4th time entery imports in a
format different from the rest. Instead of 13:30, for example, it changes it
to 1:30 PM. Try ir=t on your computer and see if it happens to you. Just
create a database with time as your only field, then create a spreadsheet
with a colum of times, save it as a text file and then import it and see what
happens to you.