Create MDB, create Table in it and import a DBF

Create MDB, create Table in it and import a DBF

Post by musa.biral » Sat, 02 May 2009 04:48:40


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.
 
 
 

Create MDB, create Table in it and import a DBF

Post by Cor Ligthe » Sat, 02 May 2009 14:30:59

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.yqcomputer.com/

To handle this there is

http://www.yqcomputer.com/

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

http://www.yqcomputer.com/

I hope this helps you on the route,

Cor

 
 
 

Create MDB, create Table in it and import a DBF

Post by Michel Pos » Sat, 02 May 2009 14:38:38


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]" < XXXX@XXXXX.COM > schreef in bericht
 
 
 

Create MDB, create Table in it and import a DBF

Post by Cor Ligthe » Sat, 02 May 2009 15:20:03

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
 
 
 

Create MDB, create Table in it and import a DBF

Post by sloa » Sun, 03 May 2009 05:09:08


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://www.yqcomputer.com/ !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.
 
 
 

Create MDB, create Table in it and import a DBF

Post by Michel Pos » Sun, 03 May 2009 15:50:31

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.yqcomputer.com/



"Cor Ligthert[MVP]" < XXXX@XXXXX.COM > schreef in bericht
 
 
 

Create MDB, create Table in it and import a DBF

Post by Cor Ligthe » Sun, 03 May 2009 16:12:35

Thanks

Cor