Hello,
I'm very new to Access VBA. I'm trying to import a csv file which needs to have certain line items modified before being imported. The first 3 fields to be imported are:
(1) (2) (3)
CC Desc. Type -->followed by numerous other fields
The type field alternates between the following six types:
CASH
REMAIN
CREDIT
REMAIN
TOTAL
REMAIN
And then it starts all over for a different CC. I need the "REMAIN' records to specify if it's a CASH REMAIN, CREDIT REMAIN or TOTAL REMAIN. I don't even know where to begin. I have only used the DoCmd.TransferText command for importing. Any suggestions?
Thanks
jm