Manage Email Signatures Centrally - For All Users

bax · Just popping in Joined: 20 Jun 2007 Posts: 3

I am trying to get all the data out of my access-database, so i can import it into sql, by using the buildinsert.exe, but whenever i run this program, it terminates wit a MS error. Any other way to get data out

brgds brian

Jesper Frier · Posted: Wed Jun 20, 2007 10:12 am Post subject: .NET 2.0

Copy your settings.mdb.

Run BuildInsert.exe from your Workstation.

Note: .NET 2.0 is required on your workstation.

Run script in Query Analyser on your SQL DB.

Post Error message or screen dump if you still have problems.

Dave Culley · Posted: Tue Jun 26, 2007 8:47 am Post subject:

Jesper,

I have a customer having a few issues using the buildinsert tool, whenever he runs it, the SQL database is populated, but when he tries to query it he gets an 'Account Field Incorrect' or a 'Syntax Error'
He has .net 3.0 on his desktop, does he also need this on his SQL Server?

Do you have any suggestions?

Thanks
Dave

Jesper Frier · Posted: Wed Jun 27, 2007 5:24 am Post subject: add image to post

Hi Dave,

I suggest that you ask your customer to add a screendump showing the error message. That can sometimes give a hint ...