Importin csv file in Access 2007

[gg]

I am having trouble importing a csv file in 2007. If I go througt the usual
import procedure,extermnal -text -make new table etc, it only works if I do
not specify that the first row contains column heads. If I do so specify,
the program either shuts down or gives me some message about trying to fix
the problem then shuts down. Help appreciated, I am about ready to put 2007
in the dumpster.

 

[Jerry Whittle]

Very strange. Go to the Office Button, then click on the Access Options
button towards the bottom. The Access Options window should open up. Go to
Resources towards the bottom of the left column. It should say the complete
version of Access (something like 12.0.6211.1000) and which Service Pack. You
should be up to SP2.

If not in the same window you can get updates.

Also in the same window is a button for run Microsoft Office Diagnostics. It
might find and fix something wrong with your install of Access.

 

[Gina Whipp]

GG,

That is strange... Wondering, what are the column header names? And have
you loaded ALL your patches?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[gg]

Thank you Jerry for quick response. I do have Svc pak 2 and ran the
diagnostics. No results. The number at bottom screen is 2007(12.0.6423.1000
SP2 MSO(12.0.6435.1000), which seems what you expected. I suppose my only
recourse is to uninstall and reinstall?

 

[gg]

Hi Gina and thanks for response. I have service pak 2 and ran diagnostics,
(see reply to Wittle above)-Are there other patches that I need? The column
heads are nothing special, most are replicas of field names in an existing
table and the import procedure worked well in my Access 2000 program I sent
the csv file to a friend with Ac2007 and worked fine there. I will get cd
back from office and reinstall, unless you can tell me some thing else to
try. Is it possible that my runtime installation is interfering?

 

[Gina Whipp]

GG,

Nothing comes to mind especially since it works on another machine. I would
use the CD to do a reinstall and see if that fixes something. If not,
perhaps Jerry has some ideas.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm