Hi,
i was trying to create an export from an .mdb file to .xlsx
my code is working but my result if i do this with vb.net i get an unsorted list.
when i try to export this with access i get the option to keep the layout.
is this also possible with vb.net?
the main reason is i want to get a sorted list is because i would like to update the prices of my data base.
the data base can't be changed.
the way i work now to do this is by exporting the access file to excelA.
i have an excelB that reads the lines of excelA en looks to another excelC (that i exported from discoverer with the prices).
this gives me an filled in excellB.
i've created a new .accdb witch is linked to this excellB.
this way i can copy past the Column from the .mdb from my .accdb.
if someone has an other idea of making this easier your welcome.
like filling in the .mdb with a lookup in the excellB would also work and maybe easier.
but because i had the excel already i tried it first this way.
i was trying to create an export from an .mdb file to .xlsx
my code is working but my result if i do this with vb.net i get an unsorted list.
when i try to export this with access i get the option to keep the layout.
is this also possible with vb.net?
the main reason is i want to get a sorted list is because i would like to update the prices of my data base.
the data base can't be changed.
the way i work now to do this is by exporting the access file to excelA.
i have an excelB that reads the lines of excelA en looks to another excelC (that i exported from discoverer with the prices).
this gives me an filled in excellB.
i've created a new .accdb witch is linked to this excellB.
this way i can copy past the Column from the .mdb from my .accdb.
if someone has an other idea of making this easier your welcome.
like filling in the .mdb with a lookup in the excellB would also work and maybe easier.
but because i had the excel already i tried it first this way.