Hi
I'm trying to import data from a CSV file into an access database and then sort it by distance and grouped by id.
so my table within the database should ideally look something like,...
ID Distance
1 3
1 4.5
1 5
1 7
I tried using a SQL select statement, but i guess I am getting it wrong...
Hi,
I am using a progress bar to display the status of some data operations that I am performing (reading data from an access database, calculating certain fields and then writing the output to a CSV file). However, after the first block on the progressbar, the screen fails to refresh and seems...
Hi
I needed some advice on a fast method to sort data. I am considering two options...
1.
Load the data into a multidimensional array and sort it. In this case, what would be the best method to sort an with approximately 3000 records and 5 fields. I'd like to sort everything based upon one of...
Thanks Wiszh
The reason I want to avoid using a recordset is because I have large volumes of data. The scenario I'm working with involves two tables..
Table1.
Field11 Field12 Field13
Table2
Field21 Field22 Field23
What I need the program to do is loop thru each record of the first...
Hi
I was wondering what the best approach to my problem would be. I have two tables table1 and table2. I need to create a third table (say table3) which has fields from both table1 and table2 and also a field that is calculated based on a function. I am using VB .NET and a MS access database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.