Writing table and data to MS Access database!

[Floppy]

Hello,

Can someone help me figuring out how to create a MS Access database, and creating tables and data into it, please?

I found this UDF but it's very old and gives me some errors.

Thank you and bye

[supersonic]

Last modified: Sunday, May 01, 2011 -- it's not soo old...

[Floppy]

Yes, but it gives me an error

Access.au3 line 291

The requested action with this object has failed.:
$oADO.Execute ("CREATE TABLE " & $adTable & '(' & $F_Out & ')')
$oADO.Execute ("CREATE TABLE " & $adTable & '(' & $F_Out & ')')^ ERROR

How can I do?

Edited February 10, 2012 by FSoft

[BrewManNH]

Do you have Access installed?

[Floppy]

No. Do I need it? If so, which version?

[Melba23]

FSoft,

That last post is worth this at the very least!

M23

[spudw2k]

You should be able to use ADODB, no Access required....I think.

[Floppy]

How can I use ADODB?

[Floppy]

Can someone teach me how to use ADODB? Thanks!

[water]

Search the forum for ADODB and you will find what you need!

[jchd]

ADODB is just like a driver component which always needs an actual (ADO compatible) DB engine behind the scene.

[Floppy]

FSoft,

That last post is worth this at the very least!

M23

I don't understand anything of this?!?

Search the forum for ADODB and you will find what you need!

I tried to search but I couldn't find any good script...

Now I installed Access 2010, but the error persist

Access.au3 line 291

The requested action with this object has failed.:
$oADO.Execute ("CREATE TABLE " & $adTable & '(' & $F_Out & ')')
$oADO.Execute ("CREATE TABLE " & $adTable & '(' & $F_Out & ')')^ ERROR

Edited February 11, 2012 by FSoft

[water]

If you work with objects you need a COM error handler to grab error information to help you debug your code.

Something like:

Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")

; Here goes your code 

; User's COM error function. Will be called if COM error occurs
Func _ErrFunc($oError)
; Do anything here.
ConsoleWrite("err.number is: " & @TAB & $oError.number & @CRLF & _
"err.windescription:" & @TAB & $oError.windescription & @CRLF & _
"err.description is: " & @TAB & $oError.description & @CRLF & _
"err.source is: " & @TAB & $oError.source & @CRLF & _
"err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
"err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
"err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
"err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
"err.retcode is: " & @TAB & $oError.retcode & @CRLF & @CRLF)
EndFunc ;==>_ErrFunc

[Floppy]

It outputs this

err.number is: 0

err.windescription: 0

err.description is: 0

err.source is: 0

err.helpfile is: 0

err.helpcontext is: 0

err.lastdllerror is: 0

err.scriptline is: 0

err.retcode is: 0

[Floppy]

I figured out I have to put that code in AccessConstants.au3

It gives this:

err.description is: La query deve contenere almeno un campo di destinazione.

err.windescription: Errore non specificato.

err.number is: 80020009

err.lastdllerror is: 0

err.scriptline is: 67

err.source is: Microsoft JET Database Engine

err.helpfile is:

err.helpcontext is: 5003000

[water]

It look like the SQL statement is wrong (if Google translated correctly from italian to german)

[Floppy]

Ok, I figured out that error is because I didn't create any primary key.

Now I created one, but I'm getting another error when I try to add a record.

It says "Type Incompatibility".

It's strange because I set the fields of the database to "text" and my script write text strings (I also tried to put the strings in String())

How can I do now? :-(

[Floppy]

Anyone knows why it says "Type Incompatibility"?

[Floppy]

Why noone helps me with this "Type Incompatibility" error?

[Juvigy]

You will have to post your code and give more details in order for someone to help you.