Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

convert .ddl file to an access db file?

how to convert .ddl file to an access db file? what tool to use?

thanks
0
she1
Asked:
she1
  • 3
  • 2
1 Solution
 
burrcmCommented:
What are you trying to achieve with the data definition language stuff? If you want to move your data or tables or structures from SQL Server to Access, just create a blank Access db and import or link via ODBC.

Chris B
0
 
she1Author Commented:
i have a .ddl file, and I don't want to create the DB myself and want to convert the .ddl
to access file.

thanks
0
 
burrcmCommented:
What created the ddl file? I assumed SQL Server for no reason that currently makes sense.

Chris B
0
 
she1Author Commented:
i know SQL is more favorable, actually, i just want to use a access file which is more easy to create in a application.

0
 
burrcmCommented:
The concept of using the ddl file to create Access tables is fine, but the SQL or code in the ddl must be understood by Access, which is why I asked where it came from. Can't really offer useful advice without seeing some data from your file, or creating my own using the same app. I have SQL Server, MySql, Informix etc.

Chris B
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now