Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
don't forget to replace "C:\MyFolder\MyWorkbook.xls" with the path and filename of your project
Is there a specific reason you are using excel as a database? It is not a very scalable method. If your users really need to access the data as an excel spreadsheet you can always give them the option to export smaller sets of data through excel.
I say this having developed applications in access, only to port them to SQL Server later on because access kept crashing with lots of data. Excel is similar, when your application is several years old with lots of data things start breaking.
Think about the whole life cycle of your application. Just some food for thought.
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...