I am trying to create a local olap cube ,populating data from access database.
On executing the code , I am getting an error, syntax error in column definition.
Could you pls tell me why this error is occuring. I have checked the column names in the database as well as the code.. They r the same..
Now , is there any other point I must look on.
Thanks in advance
Dim cnCube As ADODB.Connection
Dim s As String
Dim strProvider As String
Dim strDataSource As String
Dim strSourceDSN As String
Dim strSourceDSNSuffix As String
Dim strCreateCube As String
Dim strInsertInto As String
On Error GoTo Error_cmdCreateCubeFromDatabase_Click