Insert Record To Item Master thru ADO 1

[calbluez]

Hi All,

I write a program to port Excel data to two tables in
Mas90. The first table is IM_04AliasItemNumber, data
populated in OK.

However, when data ported in IM1_InventoryMasterfile,
data in first 16 fields looks ok, after 16th field,
some of them are ok, some go messy.

Any suggestion is appreciated.

Steve

p.s

Spec :
Mas 90
ODBC : ProvideX ODBC Drivers 3.32
Microsoft.Jet.OLEDB.4.0 / Excel 8.0
VB 6.0-SP5/ADO/SQL Commands

 

[mas90guru]

Sorry I don't have any experience writing directly to the tables - I've always used the Visual Integrator module which will import data in Excel format and put it into nearly any data file in MAS90. It handles all of the validation which you wouldn't get if you were writing directly to the tables.

Regards,

Wayne Schulz
Schulz Consulting, LLC

http://www.s-consult.com

 

[calbluez]

Thank you Wayne.

regards,

Steve