AutoCAD Electrical API to create Access DB Table

[vada1980756240]

Hello all,
I try to work on a code based on an asnwer using MS Access file. Table Created but with empty records. What I am miss?

(setq fnam "D.MDB" ) ; <- modify fnam as needed
(setq support "c:\\program files\\autodesk\\autocad 2021\\acade\\support\\en-us\")
(if (setq hdl (wd_mdb_GetHandle 4)) ; <- autocad documentation doesn't cover this secret option
  (progn
	(if (wd_mdb_Create hdl fnam 1 support)
	  (progn
		(wd_mdb_CreateTable hdl "A"
                       (list
                          (list "A" "S" 20) ; type = char string, field width = 20
                          (list "B" "S" 40)
                          (list "C" "S" 40)
                          (list "D" "S" 40)
                          (list "E" "A" 0))  ; type = autonumber
                          1  ; overwrite
		          support
                   )
	  )
	)
	(wd_mdb_Close hdl)
  )
)
(if (setq hdl (wd_mdb_GetHandle 2))
  (progn
	(if
	  (wd_mdb_Open 
		hdl 
		fnam
	  )
	  (progn
		(wd_mdb_AddRecs hdl "A"
                  (list
                    (list (list "A" "A1")(list "B" "B1")(list "C" "C1")(list "D" "D1"))
                    (list (list "A" "A2")(list "B" "B2")(list "C" "C2")(list "D" "D2"))
		  )
	      )
	  )
	)
	(wd_mdb_Close hdl)
  )
)
(wd_mdb_closeall)

[Opie]

Are you trying to create an Excel file or an Access table? The title of the thread and the text in your post are contradictory.

[vada1980756240]

I am trying to create an Access table. Thanks for help.

[Opie]

I've split your post from the original thread.

I do not use Electrical and thus do not know its API. There is a file on AUGI for working with database files called ADOLISP. This may require you to redo your code to accomplish your task. I haven't used it in many years and therefore would not be much help.

[Ed Jobe]

Do you need to do this in lisp? There is no api for lisp. Microsoft does provide a robust api in VBA. I could help you with that. Would you like me to move this to the VBA forum?

[vada1980756240]

Thanks for help! I need to do this in lisp but VBA is perfect solution too for my task.

[Ed Jobe]

I've done tons of db work, but never in lisp. Apparently, you are referencing some other library to do your work. You should provide such information to get help with it... or make the switch to another language. NET also has great db api's and built in tools, plus it can create lisp commands. That might be a way to continue with lisp. However, .NET has a steep learning curve.