I'm using RODBC to read an excel file (not mine!).  But I'm struggling to find a way to preserve the column names that have a numeric value.  sqlFetch() drops the value and calls them f1, f2, f3,... (ie field number).  this is a different approach from read.csv, which will append "V" prior to the numeric column name.  sqlFetch isn't so helpful. 
 
Is there a way to get the first line of data from the excel file and place it in a vector?  Perhaps I can use that method and rename the dataframe column names later?
 
thanks!
Michael
 
_______________________________________________________
Michael Folkes
Salmon Stock Assessment
Canadian Dept. of Fisheries & Oceans     
Pacific Biological Station
3190 Hammond Bay Rd.
Nanaimo, B.C., Canada
V9T-6N7
Ph (250) 756-7264 Fax (250) 756-7053  Michael.Folkes@dfo-mpo.gc.ca <mailto:Michael.Folkes@dfo-mpo.gc.ca> 

	[[alternative HTML version deleted]]

