We need to import data that has been exported from our Mass Spectrometer into Access.
Nothing is ever straightforward.
The attached zip file contains 3 files.
File 1) "072823 as exported from Mass Spec software.csv" This is the datafile generated by exporting the results of a run of several samples from our Mass Spec. Lots of stuff we dont need in our table.
File 2) "072823 formatted for import into Access tbl 537.csv" This file was created from File 1 above. We use excel VBA to format the csv to use for import into Access tbl537.
File 3) "tbl537.accdb" The database contains one table showing the results from importing the file formatted for import (File 2) into access.
So, we take the file generated from the mass spec, use excel to format it for import, then fire up Access and import the formatted file.
I am just getting started with access. I know Excel VBA pretty well. It just seems like I have one too many steps in the process.
I tried to import the file from step one directly into Access. That was a no go. On the other hand, we're trying to wean ourselves off Excel as much as possible.
Is there a relatively straitghtforward way to format File 1 within Access so that it can be imported into tbl537 without the intermidiary use of excel to create the formatted file for import (File 2)?
Note: File 2 deletes 3 rows from File 1 and also gets the file headers all set.
I aplogize for the cumbersome file names.
As always, thanks for taking a look.