|
| | | Forum Newbie
Group: Forum Members
Last Login: 4/18/2007 1:27:00 PM
Posts: 4, Visits: 10 |
| Right now our output file is a csv with two columns. I mapped it to Point (using the column headers and field ids) but do I need to convert it so that the information is in two rows instead of columns? I'm having problems since the csv format only allows for 256 columns and we have more fields than that. Is there a better option having our program export to a txt file and what's the best format for that?!?
Thanks! |
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| | who is limiting you to 256 columns? a point file would be all on one row. So you would have columns like column header first name last name.... row data John,Homeowner Andy,America does this help? You might try tab delimited from your other system maybe they will let you output more information.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 4/18/2007 1:27:00 PM
Posts: 4, Visits: 10 |
| excel is limiting me to 256 columns!!
So if I do a regular tab delimited, would I just save it as a .txt file?
Thanks! |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| .txt or .dat
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| | Depending on what you're trying to accomplish, you might consider importing the data into a MS SQL database (or MySQL for a free version). You may have to split it between multiple tables. You could also accomplish that with Excel by importing into multiple worksheets. If you are looking for a reporting function, you could use Crystal Reports, although I recommend version 10 and below. This would give you greater power over analyzing so much data. More than 256 columns is difficult to push into a useful format. What is your end objective?
- Mike
mike@mtig.biz |
| |
|
|