Split Excel Worksheet Data into Access header/footer

M

Maureen

Good Morning,

I would like to take purchase orders received in excel from our customers
and stuff the information into access header/footer. The access
header/footer is in an order processing application that I have inherited as
part of an EDI app. Once the details are here, the PO's are automatically
"stuffed" into our enterprise system. The excel come from chain of 15 stores
and will often have over 100 items on each order. This chain is very very
successful and has no plans to move to EDI has no plans to change what they
are The format of the excel sheet is below. I have done a little bit of work
in VB but am very new. I do not have $$$ budget available to have code
developed to handle this and I would like to try and learn/test and do it on
my own. Any tips or pointers to code samples would be appreciated.

PO# 3203805
UPC TITLE Disc RETAIL ST-10 ST-11
111222333444 Title 55 $19.99 45 18



Thanks in advance,
M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top