HELP on Upgrade from 6.1 to 8.12

We are implementing 8.03 and we are having issues with the menu security. We are moving from 6.1 to 8.0 to 8.12. The menu security was okay on the first move but now we've lost it on the second one.

The user security came through perfect. Has anyone had this issue? Is there a switch or patch that you know of to fix this?

Barb Hemme


[Non-text portions of this message have been removed]
Does anyone have a snippet of code to show how to call up an excel file if I have the address?

The purpose is to create a group list of BOM parts to update. I thought to read in a spreadsheet and then added the list to a grid.
here are the basics, mypath has the file name in it. I have a more complete example around somewhere that shows how to load data into a UD table from Excel.

System.Data.DataSet DtSet;

DtSet = new System.Data.DataSet();

System.Data.OleDb.OleDbDataAdapter MyCommand;

MyConnection = new System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0; data source='" + myPath + " '; " + "Extended Properties=\"Excel 8.0;IMEX=1\"");
MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$]", MyConnection);

MyCommand.Fill(DtSet);
//DtSet.WriteXml(Environment.GetFolderPath(Environment.SpecialFolder.Personal)+ "\\Test.xml", XmlWriteMode.WriteSchema);
// this is a grid I used to display the data
ExcelData.DataSource = DtSet;
ExcelData.DataBind();

// Your first row should have the names you want the fields to have

MyConnection.Close();

Jim Kinneman
Senior Consultant
Encompass Solutions Inc

--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey_amc@...> wrote:
>
> Does anyone have a snippet of code to show how to call up an excel file if I have the address?
>
> The purpose is to create a group list of BOM parts to update. I thought to read in a spreadsheet and then added the list to a grid.
>