SQL to Access

[scot22]

I have a file (*.sql) which contains all the necessary SQL to create and populate a database (lucky me). I want to create this as a *.mdb database via Access. Firstly is this possible and secondly how is the best way to go about it?

 

[KenHigg]

I don't understand how a .sql could populate a db but...

My guess is you'd be best to do the thing in sql, then attach to and copy the objects in Access.

But then again I'm rather green in sql sever

 

[scot22]

I know from my university days using a Postgres that SQL statements can create and populate databases. The sql file just contains in plain text all the statements necessary to do this and I want to create this as an Access database.

 

[RV]

I know from my university days using a Postgres that SQL statements can create and populate databases.

Access isn't actually a database.
So you can't populate an Access "database" by simply running a .sql file which in fact you can do on real relational databases.

You also need to take into account that Access comes with it's own "version" of SQL.

Can't tell you if what you want is achievable (I guess so, it's nor likely going to be easy) and how to.

RV

 

[Pat Hartman]

If you want to copy data from a different database into Access, there are a couple of ways to accomplish the task but using an .SQL file isn't one of them unless you want to write the code necessary to interpret it.

The easiest thing to do is to link the Access db to the SQL db and just import the tables.

A more difficult alternative is to export .csv or .xls files from the database and then import those files into Access as tables.