Worksheets to DataSet

[sambos]

Hello,

I'm having trouble reading and storing worksheets into a dataset. This is my code:

DataSet^ ds = gcnew DataSet();

String^ ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\test.xlsx;Extended Properties=\"Excel 12.0 XML;HDR=YES\""; 

	for(int i = 1; i<21; i++)
	{
		DataTable^ dt= gcnew DataTable();
		OleDbConnection^ conn = gcnew OleDbConnection(ConnectionString);

		OleDbCommand^ com = gcnew OleDbCommand();
		com->Connection = conn;
		com->CommandText = "select * from [Week " + i.ToString() + "]";
		OleDbDataAdapter^ adap = gcnew OleDbDataAdapter();
		adapt->SelectCommand = com;
		adapt->Fill(dt);

		ds->Tables->Add(dt);
		ds->Tables[i-1]->TableName = "Week " + i.ToString() + ";

		conn->Close();
	} 

Each Worksheet is labelled Week 1 to Week 20. I would like all worksheets to be loaded into the dataset. I was hoping that I could just do a simple loop but the only table that gets read and placed into the dataset is the first worksheet, Week 1.

No doubt it's something simple.

Any suggestions would be great!

[sambos]

It appears that I've solved my own problem... The line:

com->CommandText = "select * from [Week " + i.ToString() + "]";

needs to be:

com->CommandText = "select * from [Week" + i.ToString() + "$]";

Cheers,