humbleprogrammer
Programmer
Hello,
I am hoping someone can help me find a solution for this. I have reports in .txt format that I receive from outside offices. I need to import these files into Access and then match the data to existing orders. That's all fine but the report formats have the data on 2 lines like below:
orderno amount name phoneno
orderstatus
I need to update the order status info per order number but the order status is on a separate line. Does anyone know how I can import the data and somehow associate the order status with the orderno from the line directly above it? Any help would be greatly appreciated.
Thanks!
I am hoping someone can help me find a solution for this. I have reports in .txt format that I receive from outside offices. I need to import these files into Access and then match the data to existing orders. That's all fine but the report formats have the data on 2 lines like below:
orderno amount name phoneno
orderstatus
I need to update the order status info per order number but the order status is on a separate line. Does anyone know how I can import the data and somehow associate the order status with the orderno from the line directly above it? Any help would be greatly appreciated.
Thanks!