import from MS Access

["Liu Zhigang" <email.lzg@gmail.com>]

Dear all,

 

          I have a MS access database on disk, D:\stock.mdb;

         and I tried to import a table named nyse  from this access file into S+,  my code is following,

 

                price <- importData(file ="D:\\stock.mdb" ,type="ACCESS",

                              sqlquery="SELECT * FROM  nyse")

 

            But the dataframe of price I got was not nyse in access database,  it was from a another table of stock.mdb.

 

            anyone can tell me the where wrong is ?

              Thanks.

 

                 Lau ChiKong