InertiaM
Well-known member
I need to create a standalone database using data from a SQL Server. I've tried :-
but it's looking for the Jet database on the server, not on my local PC. Does anyone have any ideas
VB.NET:
sSQL &= " INSERT INTO OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\blank.mdb; Jet OLEDB:Database Password=blank;')...tblTest"
sSQL &= " SELECT ........" etc
but it's looking for the Jet database on the server, not on my local PC. Does anyone have any ideas