R
Ron Berns
I receive a text file that contains two types of records, a header
record and a detail record. Currently I import the file into Excel, sort
the records, make spreadsheet for the header records and a spreadsheet
for the detail records. Then I import each spreadsheet into the
respective table in Access.
"H",43251284,20090328,"ST","W-M/BOF #1470",12,23.52
"D",12,"EA",1.96,"UP","076721404687","VN","407990"
"H",35114677,20090330,"ST","W-M/BARRELL O'FUN #1861",21,53.04
"D",9,"EA",3.28,"UP","076721394551","VN","408600"
"D",12,"EA",1.96,"UP","076721396050","VN","425730"
"H",35204575,20090330,"ST","W-M/BARRELL O'FUN #3513",29,77.60
"D",8,"EA",3.28,"UP","076721394575","VN","043950"
"D",12,"EA",1.82,"UP","076721403758","VN","408400"
"D",9,"EA",3.28,"UP","076721394551","VN","408600"
I was wondering if it is possible to write some code to read this
text file and automatically import the data into each database.
I am hoping that someone could point me in the right direction.
Thanks in advance.
Ron
record and a detail record. Currently I import the file into Excel, sort
the records, make spreadsheet for the header records and a spreadsheet
for the detail records. Then I import each spreadsheet into the
respective table in Access.
"H",43251284,20090328,"ST","W-M/BOF #1470",12,23.52
"D",12,"EA",1.96,"UP","076721404687","VN","407990"
"H",35114677,20090330,"ST","W-M/BARRELL O'FUN #1861",21,53.04
"D",9,"EA",3.28,"UP","076721394551","VN","408600"
"D",12,"EA",1.96,"UP","076721396050","VN","425730"
"H",35204575,20090330,"ST","W-M/BARRELL O'FUN #3513",29,77.60
"D",8,"EA",3.28,"UP","076721394575","VN","043950"
"D",12,"EA",1.82,"UP","076721403758","VN","408400"
"D",9,"EA",3.28,"UP","076721394551","VN","408600"
I was wondering if it is possible to write some code to read this
text file and automatically import the data into each database.
I am hoping that someone could point me in the right direction.
Thanks in advance.
Ron