Hello everyone,
I have two questions.
1. How can I import a CSV file into access programmatically?
2. The file that I’m importing has separate records for a work order for example.
w/o# custname custphone# address equiptment1
w/o# custname custphone# address equiptment2
w/o# custname custphone# address equiptment3
w/o# custname custphone# address equiptment4
When I import the CSV file into access manually I get multiple records for a w/o depending on the equipment the customer has. So what I’m trying to do is instead of having multiple lines for one w/o I want everything on one line (one record) e.g.
w/o# custname custphone# address equiptment1 equiptment2 equiptment3 equiptment4
Thanks in advance.
I have two questions.
1. How can I import a CSV file into access programmatically?
2. The file that I’m importing has separate records for a work order for example.
w/o# custname custphone# address equiptment1
w/o# custname custphone# address equiptment2
w/o# custname custphone# address equiptment3
w/o# custname custphone# address equiptment4
When I import the CSV file into access manually I get multiple records for a w/o depending on the equipment the customer has. So what I’m trying to do is instead of having multiple lines for one w/o I want everything on one line (one record) e.g.
w/o# custname custphone# address equiptment1 equiptment2 equiptment3 equiptment4
Thanks in advance.