sql command for reading a particular sheet, column

sql excel r sqlcommand import-from-excel
Alphaneo picture Alphaneo · Jul 29, 2009 · Viewed 13.9k times · Source

This is probably a very stupid question for SQL stalwarts, but I just want one SQL command.

Details,

I am using a data analysis tool called R, this tool uses ODBC to read data from XLS. I am now trying to read data from an XLS file. The ODBC tool in R accepts SQL commands.

Question,

Can someone give me an SQL command that will read data from an XLS file's - Specified sheet - Specified column [by name] - Specified row [Specified just by Row Index]

Thanks ...

Answer

Rashid picture Rashid · Jan 12, 2010

With the query below you can read the data from row 61 of cloumn A, & G is supposed to read all columns till G.

SELECT * FROM [Sheet1$a61:G]

Related questions

Generate sql insert script from excel worksheet

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert script from this excel worksheet?

Read More
How to run a SQL query on an Excel table?

I'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn't null. I could do this pretty easy with SQL, but I have no clue how …

Read More
Export SQL query data to Excel

I have a query that returns a very large data set. I cannot copy and paste it into Excel which I usually do. I have been doing some research on how to export directly to an Excel sheet. I am …

Read More