var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: converting raw sql to access
i have and .sql file that looks like it generates a table for a project. i'm very new to databases and i'm not sure how i use my ms access to "run" this code to create the database. please help!!!
Need A Sample File Will try To Work On
attached is what i received from the company
i'm okay with databases if i make them but not sure what to do with this. i think the one "define" file needs to be executed to create the data base but not sure how to do it. thanks for your help!!!
most of the file sizes were huge so i had to delete some of the rows of contents.
The Files You Sent Are Txt File And They Are Not To Create A Data Table If You Need To Import Them To Access Is Possible But It's HArd Work
If You Want To Try Open A New Access mdb File And Choose Import From Menu Mark The File You Need And You Will Find Everything Is Self Explained....
Sorry I Could Not Help You More
the define file is actually a sql file
check the mls_define file, it's the sql file
You Are Right
mls_define file is sql Script
I Have Pasted To Query Analyzer In SQL And Generated the The Table Attached In An MDB Format
But I Could Not Import Data In Txt Files As There Is No Fixed Delimited Or Fixed Width To Work On
could you tell me how you did this?
thanks so much for your help, can you tell me how you did this? thanks again!!!
As I Mentioned Earlier The File mls_define is An SQL Script File.
It is Like A code Than Can Be Read By The SQL Query Analyzer To Create Tables.
The Script Has Command Lines That Tells Sql What Table To Create And What To Name It Also The Names Of The Fields That Should Populate The Table Created.
To Be Able To Do It You Need To Have Sql Server On Your Machine
After This Operation I Have Exported The Files To MDB Format That Can Be Read By MSAccess.
thanks!!! just what i was looking for!!!!