Hi all, 
Please I need assistance to create bill of materials maintenance window 
macro to upload large amount of data.
if anybody has it ready or is there another way to upload bill of material 
data please let me know.

I really appreciate your support.

Hi GPUser,

You can use the 'mail merge' macro creation routine to pull information from 
a file. This method will allow for validation because it mimics a person 
actually entering the data. Another option is to update the tables directly 
using SQL. To my knowledge the only tables involved in BOM setup are:

BM00111 Bill of Materials Compnent
BM00101 Bill of Materials Header

I usually use Import Utility for these imports, it's fast and I don't have 
to use SQL tools. I'm lazy and often am not working at a computer with the 
SQL Management Studio installed.

Kind regards,

Leslie

"GPUser" wrote:

> Hi all, 
> Please I need assistance to create bill of materials maintenance window 
> macro to upload large amount of data.
> if anybody has it ready or is there another way to upload bill of material 
> data please let me know.
> 
> I really appreciate your support.

Check the Dynamic Community, I posted a replay on that forum.

"GPUser" wrote:

> Hi all, 
> Please I need assistance to create bill of materials maintenance window 
> macro to upload large amount of data.
> if anybody has it ready or is there another way to upload bill of material 
> data please let me know.
> 
> I really appreciate your support.

Hi,

Table Imports sounds a good idea I will try it hope it works.

Thanks

"Leslie Vail" wrote:

> Check the Dynamic Community, I posted a replay on that forum.
> 
> "GPUser" wrote:
> 
> > Hi all, 
> > Please I need assistance to create bill of materials maintenance window 
> > macro to upload large amount of data.
> > if anybody has it ready or is there another way to upload bill of material 
> > data please let me know.
> > 
> > I really appreciate your support.

I made a macro before, please drop me a mail and I will send you the files.

Regards,
-- 
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohdaoud@gmail.com
http://mohdaoud.blogspot.com/

"GPUser" <GPUser@discussions.microsoft.com> wrote in message 
news:61135851-264F-4E5B-A311-99E72E0EBE97@microsoft.com...
> Hi,
>
> Table Imports sounds a good idea I will try it hope it works.
>
> Thanks
>
> "Leslie Vail" wrote:
>
>> Check the Dynamic Community, I posted a replay on that forum.
>>
>> "GPUser" wrote:
>>
>> > Hi all,
>> > Please I need assistance to create bill of materials maintenance window
>> > macro to upload large amount of data.
>> > if anybody has it ready or is there another way to upload bill of 
>> > material
>> > data please let me know.
>> >
>> > I really appreciate your support.