Create MDB, create Table in it and import a DBF

[musa.biralo]

Hi there:

I am very beginner in .NET (have little knowledge of VBA) so seeking
some help, direction, code... anything...

I am trying to do three things. 1) Create a MDB file 2) then create a
simple table in the MDB and 3) import a DBF to the MDB.

I googled for creating MDB file and there are nice out there but the
problem is at importing DBF table. I feel like the method may not
support the importing the dbf file... but anyway, if you could help me
that will be great... if not, i will not say anything as i know i am
seeking little more...

Thanks for your time...
I am just a simple guy who is interested in programming but does not
have whole bunch of knowledge... Imagine the pain of having interest
but not knowing even not getting what i spent time for ......

Thanks again.
musa.

 

[Cor Ligthert[MVP]]

Musa,

Start with stopping to try to use an MDB database. That is at the end of its
lifecycle.

For the same you can use the free SQL server Express 2008

http://www.microsoft.com/downloads/...C2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

To handle this there is

http://www.microsoft.com/downloads/...C2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

To create things in code using SQLTransact script you need the command
ExecuteNonQuery

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

I hope this helps you on the route,

Cor

 

[Michel Posseth [MCP]]

Cor ,


A bether replacement for Access would be IMHO SQLSERVER CE

Why ?

They are both local file based , they both have a simple deployment scheme ,
they both have the same security capabilities


Michel

 

[Cor Ligthert[MVP]]

Michel,

I simple don't have any experience with the SQL Server CE, the only thing I
know is that Bill Vaughn writes this always too.

I am curious about the fact if you can manage that in the same way with SQL
server management, any experience with that?

Cor

 

[sloan]

Sql Server Express
or
Sql Server CE

are better options (these days) for a JET database. (Jet database is a
better (correct) term for a "an access database").

........

I think you can learn some valuable "birds eye view" stuff from this:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry
code is downloadable.

Look at the URL's I mention in this file:
README_HELP_WITH_CE.txt

Follow the "johnny can't code" url's. He has some very good import
information about CE.

 

[Michel Posseth [MCP]]

Hello Cor ,

SQL CE databases can be created and managed from Microsoft Visual Studio and
SQL Server Management Studio


here is all info to take it for a test drive

http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx

 

[Cor Ligthert[MVP]]

Thanks

Cor

Hello Cor ,

SQL CE databases can be created and managed from Microsoft Visual Studio
and SQL Server Management Studio


here is all info to take it for a test drive

http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx