Hi,
I want to export item information from my database (i.e. which items were
sold for a certain time period) I want to then import that information into
Excel. What I am looking to do is set up a template where I create an item
line in Excel with full description of cases, U/M, size etc, and when I
import data from my database it will look at the item number and fill in the
rest of the line. Does anyone know how to accomplish this?

Thank You,
Matt

Hi

One way of doing this is to use a VLOOKUP function on whichever column is
common to both sets of data (part number?). If you post a sample layout (in
plain text), we can advise you further.

Andy.

"Matt" <(E-Mail Removed)> wrote in message
news:40283875-9AC0-4579-B228-(E-Mail Removed)...
> Hi,
> I want to export item information from my database (i.e. which items were
> sold for a certain time period) I want to then import that information
> into
> Excel. What I am looking to do is set up a template where I create an
> item
> line in Excel with full description of cases, U/M, size etc, and when I
> import data from my database it will look at the item number and fill in
> the
> rest of the line. Does anyone know how to accomplish this?
>
> Thank You,
> Matt

Hi Andy,
Thanks for the response.

But the VLOOKUP would be used after I create the template right? How do i
create the temlate? Just put all the products and description in a regular
Excel page. Do I need to include certain formulas? An example of what a
line would look like.

45678 creamy peanut butter 20/40oz CS

Like 4 - 6 fields. All I would extract from my database would be the item
number.

Thanks.

"Andy" wrote:

> Hi
>
> One way of doing this is to use a VLOOKUP function on whichever column is
> common to both sets of data (part number?). If you post a sample layout (in
> plain text), we can advise you further.
>
> Andy.
>
> "Matt" <(E-Mail Removed)> wrote in message
> news:40283875-9AC0-4579-B228-(E-Mail Removed)...
> > Hi,
> > I want to export item information from my database (i.e. which items were
> > sold for a certain time period) I want to then import that information
> > into
> > Excel. What I am looking to do is set up a template where I create an
> > item
> > line in Excel with full description of cases, U/M, size etc, and when I
> > import data from my database it will look at the item number and fill in
> > the
> > rest of the line. Does anyone know how to accomplish this?
> >
> > Thank You,
> > Matt
>
>
>

Hi
Any format of template would be fine - as long as it does the job for you!
Make sure that the 'common' field is in the first column - it makes it
easier for the VLOOKUP formula. You need to use it as a reference point.

Andy.

"Matt" <(E-Mail Removed)> wrote in message
news:9201A0AC-4DD4-4554-9D75-(E-Mail Removed)...
> Hi Andy,
> Thanks for the response.
>
> But the VLOOKUP would be used after I create the template right? How do
> i
> create the temlate? Just put all the products and description in a
> regular
> Excel page. Do I need to include certain formulas? An example of what a
> line would look like.
>
> 45678 creamy peanut butter 20/40oz CS
>
> Like 4 - 6 fields. All I would extract from my database would be the item
> number.
>
> Thanks.
>
> "Andy" wrote:
>
>> Hi
>>
>> One way of doing this is to use a VLOOKUP function on whichever column is
>> common to both sets of data (part number?). If you post a sample layout
>> (in
>> plain text), we can advise you further.
>>
>> Andy.
>>
>> "Matt" <(E-Mail Removed)> wrote in message
>> news:40283875-9AC0-4579-B228-(E-Mail Removed)...
>> > Hi,
>> > I want to export item information from my database (i.e. which items
>> > were
>> > sold for a certain time period) I want to then import that information
>> > into
>> > Excel. What I am looking to do is set up a template where I create an
>> > item
>> > line in Excel with full description of cases, U/M, size etc, and when I
>> > import data from my database it will look at the item number and fill
>> > in
>> > the
>> > rest of the line. Does anyone know how to accomplish this?
>> >
>> > Thank You,
>> > Matt
>>
>>
>>