r - RODBC and Access - Loading data -


I am trying to load some data from the Access database to R. I can say that to use odbcConnectAccess ("file.mdb") I can not load this function on all the instructions. Has it been altered or changed its name? Is there another way to do this? I still have no luck at RODBC with the library ("Loaded with RODBC").

Thank you!

If you are using on a Mac, then I use drivers to connect to Access database Has achieved success by doing so. If you have already set up the ODBC connection, then using the Odyssey Source Administrator on Mac, the rest of Windows or the Odbi administrator are quite simple. 

  Library (RODBC) # Open the database, supply the name of the name of the ODBC connection and user name data. Lt; -odbcConnect ("ODBC_Connection_name", uid = "user_name")   
 There is also an option to provide password in the ODBC Connect, but I have set up the connection with "password" .  
  sqlTables (data.ch) # Check the connection for all tables # Get all the data from a table called "table_name" or use standard SQL statement Df & lt; -sqlFetch (data.ch, "Table_name")

Comments

Post a Comment