D
Duck
I work for an eyeglasses retailer, and I am creating a database to
monitor our inventory. I want to be able to provide our many vendors
with a spreadsheet which they will receive by email, and complete to
tell us exactly what is being sent to our store with each order. I
will then import the spreadsheet directly into our inventory
database. My problem is that there will be information such as Vendor
Name, P.O.#, billing terms, etc that is the same for each item in the
order, and is more appropriate to include in the header of the
spreadsheet instead of as seperate fields for the vendors to fill
out.
How can I extract information from the header of the spreadsheet, and
convert them into columns necessary for each record that will be
imported into the inventory database??
monitor our inventory. I want to be able to provide our many vendors
with a spreadsheet which they will receive by email, and complete to
tell us exactly what is being sent to our store with each order. I
will then import the spreadsheet directly into our inventory
database. My problem is that there will be information such as Vendor
Name, P.O.#, billing terms, etc that is the same for each item in the
order, and is more appropriate to include in the header of the
spreadsheet instead of as seperate fields for the vendors to fill
out.
How can I extract information from the header of the spreadsheet, and
convert them into columns necessary for each record that will be
imported into the inventory database??