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 [email protected]
<mailto:[email protected]>
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
