Getting SQL code from an ERD in LucidChart into MS Access to Create a Database

Best Microsoft Access Programmer Portland OR

Getting SQL code from an ERD in LucidChart into MS Access to Create a Database

[Edited to fix duplicate picture issue]

Hello All,

I’m a student who has created an ERD in LucidChart and is trying to import the SQL code into Access (2016) to create a database. After a few hours of searching, all I’ve been able to find is importing from a server or importing from a text file. I don’t have a server, so I’ve tried the text file method and the delimiters don’t seem to be pulling the database in correctly. I’m guessing that one delimiter won’t do here. Is there another way to do this? I was hoping Access had a plain SQL input section that would allow me to dump the code and it would magically build the database for me.

The first picture are my options for the SQL format on export from LucidChart. The second is what it looks like in import wizard.

Export options in LucidChart

Delimiter issue in Access 2016

I would be very greatful for any help.

submitted by /u/mob43
[link] [comments]

Get the best Microsoft Access consultant

Get the best Microsoft Access programmer

Microsoft Acess Developer Portland OR