Rearranging columns in queries and tables

[tryingtowork]

Ok so here's my big problem i have: I am trying to sort data from a csv file.
The data contains fields like date, time, tag name, and value. The ultimate
goal is to display this data as graphs in excel for different date ranges.
However, the problem is the tag name field has multiple tag names in one
column which i need separated out. I was originally going to just sort the
columns in excel but this is a HUGe amount of data and there are only about
65,000 rows displayed in excel so it gets cut off. The best way i can figure
out to sort the tag names is with queries in Access. This way i have been
able to get Date, Time, etc. for tags 1, 2, and so on with their
corresponding values. I have been trying to combine the queries together but
it keeps crashing Access. It will say preparing query and then after 5
minutes or so a window pops up saying there is not enough temporary space on
my disk. I'll try removing some files to make some room but i'm still not
sure if this is the best way to go about sorting this data. If anyone has any
suggestions i would appreciate it. Thanks,

 

[KARL DEWEY]

You did not say how you trying to combine the queries together. Are you using
join or union? Did you try with small sample data?
Post the SQL of your queries.

 

[John W. Vinson]

Ok so here's my big problem i have: I am trying to sort data from a csv file.
The data contains fields like date, time, tag name, and value. The ultimate
goal is to display this data as graphs in excel for different date ranges.
However, the problem is the tag name field has multiple tag names in one
column which i need separated out. I was originally going to just sort the
columns in excel but this is a HUGe amount of data and there are only about
65,000 rows displayed in excel so it gets cut off. The best way i can figure
out to sort the tag names is with queries in Access. This way i have been
able to get Date, Time, etc. for tags 1, 2, and so on with their
corresponding values. I have been trying to combine the queries together but
it keeps crashing Access. It will say preparing query and then after 5
minutes or so a window pops up saying there is not enough temporary space on
my disk. I'll try removing some files to make some room but i'm still not
sure if this is the best way to go about sorting this data. If anyone has any
suggestions i would appreciate it. Thanks,

I would suggest Importing, not linking, the data into a properly indexed
Access table. 65k records is big for (older versions of) Excel but very minor
for Access (6.5 million rows is getting a bit big).

Note that Date and Time are reserved words and will give Access some trouble.

You might want to post an example of this "tag name" field for suggestions how
best to incorporate it in your table.