Importing players.csv into MS Access

sfgiants88 · 11-26-2005, 04:30 AM

I created the csv reports through comish joe's exporter and want to open up players.csv in access to create a query.

I went through the process of importing players.csv as a table and I get to the following screen where I have to select data type as "text" instead of "long integer" so that Access doesn't blow up when importing the data. However, I have to manually change it for each of the 172 fields. Is there a faster way to do this?

Am I totally taking a wrong approach?

Any help would be appreciated.

battists · 11-26-2005, 09:12 AM

sf, I recommend creating a link table to the CSV. When you do this, it will do a wizard. Tell it that " is the text identifier, and that the first row contains headers. Then skip all of the individual field settings.

This gives you a table that gets automatically refreshed any time you re-export!

That works great for me! I usually do the same with the fielding file, and then join them via the relationship mgr.

PM me if you need more info!

sfgiants88 · 11-26-2005, 09:46 PM

Worked like a charm.

Thanks a ton, Steve.

battists · 11-26-2005, 10:19 PM

No problem. I'm pretty familiar with the different data fields now, so if you're not sure how to get at something, just send me a PM!

11-26-2005, 04:30 AM	#1
sfgiants88 All Star Reserve Join Date: Jan 2005 Posts: 885	Importing players.csv into MS Access I created the csv reports through comish joe's exporter and want to open up players.csv in access to create a query. I went through the process of importing players.csv as a table and I get to the following screen where I have to select data type as "text" instead of "long integer" so that Access doesn't blow up when importing the data. However, I have to manually change it for each of the 172 fields. Is there a faster way to do this? Am I totally taking a wrong approach? Any help would be appreciated. Attached Images Last edited by sfgiants88; 11-26-2005 at 04:37 AM.

11-26-2005, 09:46 PM	#3
sfgiants88 All Star Reserve Join Date: Jan 2005 Posts: 885	Worked like a charm. Thanks a ton, Steve. Last edited by sfgiants88; 11-26-2005 at 10:19 PM.

11-26-2005, 09:12 AM	#2
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	sf, I recommend creating a link table to the CSV. When you do this, it will do a wizard. Tell it that " is the text identifier, and that the first row contains headers. Then skip all of the individual field settings. This gives you a table that gets automatically refreshed any time you re-export! That works great for me! I usually do the same with the fielding file, and then join them via the relationship mgr. PM me if you need more info!

11-26-2005, 10:19 PM	#4
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	No problem. I'm pretty familiar with the different data fields now, so if you're not sure how to get at something, just send me a PM!