Displaying 1 result from an estimated 1 matches for "sqlname".
Did you mean:
selname
2000 Mar 08
0
RODBC: follow up
....matrix(names(dat)) ?
(4) in sqltablecreate
gsub("[^A-Za-z]+", "", as.character(coldata[i, 4]))
destroys numbers in column names, rather use
gsub("[^A-Za-z0-9]+", "", as.character(coldata[i, 4]))
Furthermore think about substituting '_' in SQLNAMES to '.' in
RNAMEodbcColumns(channel, table)S and vice versa.
gsub("[.]", "_", RNAME)
gsub("[_]", ".", SQLNAME)
(5) in several functions you use
if (!any(sqlTables(channel) == sqtable)) )
shouldn't that read
if (!any(sqlTables(channel)...