Problem with ODBC from FileMaker - can read labels but not data
Hi, I've encountered a snag when trying to create a dataframe from FileMaker data. For what it's woth, I'm uising FileMaker Pro 11, FileMaker's ODBC driver, and ODBC Administrator on MacOS Lion. I am able to sucessfully make the connection. Thus,
library(RODBC)
myconn <- odbcConnect ("AGA_1","Admin","********")
D <- sqlFetch (myconn,"DATA_AGANorway")
executes and gives no error messages. However,
D
gives a list of all of the label names of the table (53 in all), but without the variables.
fix(D)
confirms this: The editor labels the columns correctly, but the cells are empty. Is this expected behavior, or a bug? Have I overlooked something? Any and all help appreciated! Thank you,
Rolf Marvin B?e Lindgren Grendel evidenbasert psykologi +47 400 61 755 [[alternative HTML version deleted]]