Problem in reading Excel spreadsheets

Hi folks,

Win 7 64bit
R 2.12.0 32bit

Problem in reading Excel spreadsheets

(the text file, research_databaseI.xls, was download on Internet)

data=odbcConnectExcel(file.choose())
sqlTables(data)

                                                  TABLE_CAT TABLE_SCHEM
1  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
2  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
3  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
4  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
5  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
6  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
7  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
8  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
9  C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
10 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
11 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
12 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
13 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
14 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
15 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
16 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
17 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
18 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
19 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
20 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
21 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
22 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
23 C:\\Users\\satimiswin764\\Documents\\research_databaseI<NA>
                       TABLE_NAME   TABLE_TYPE REMARKS
1                           AGR$ SYSTEM TABLE<NA>
2                           BMC$ SYSTEM TABLE<NA>
3                         Dairy$ SYSTEM TABLE<NA>
4                           GDP$ SYSTEM TABLE<NA>
5                          HIES$ SYSTEM TABLE<NA>
6                         Manuf$ SYSTEM TABLE<NA>
7                        Prices$ SYSTEM TABLE<NA>
8                        Sheet1$ SYSTEM TABLE<NA>
9                           WPI$ SYSTEM TABLE<NA>
10             'Approved plans$'        TABLE<NA>
11                  'Emp stats$'        TABLE<NA>
12                   'Ex rates$'        TABLE<NA>
13            'hotel occ rates$'        TABLE<NA>
14               'Insurance co$'        TABLE<NA>
15             'Interest rates$'        TABLE<NA>
16                    'Motor V$'        TABLE<NA>
17           'Ostrich Projects$'        TABLE<NA>
18                   'Prop dev$'        TABLE<NA>
19                'tourism est$'        TABLE<NA>
20 'tourism est'$_FilterDatabase        TABLE<NA>
21              'Travel agents$'        TABLE<NA>
22               'Umempl stats$'        TABLE<NA>
23                     'US CPI$'        TABLE<NA>

mydata=sqlFetch(data, "AGR")
odbcClose(data)
mydata

The printout doesn't look like the content of Excel spreadsheet.  Many data
disappear.

I read ?RODBC and the pdf file started with "RShowDoc("RODBC",
package="RODBC").  I couldn't figure out the cause of problem.


Is "RODBC" not the way to read Excel spreadsheets on R?  TIA

B.R.
Stephen L


	[[alternative HTML version deleted]]