asked on

Running sql script and loading flat file data into MSAccess 2007 database

Hello,

I have a huge sql script which needs to be executed in MS Access database to load data.

Question 1:
Which is the best way to execute the script given that its close 999MB?

Question 2:
Is there a way to run it from command line? Would that be faster?

Question 3:
I also have data in flat file that needs to be loaded into Access database.
Will BCP work against Access database? If not, is there a equivalent of BCP to bulk load data into Access database?

Thanks!

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sath350163

ASKER

I have a sql script with insert and update statements that needs to be executed every month against a MS Access 2007 database.
The sql script size is 1GB and have multiple insert and update statements.
To be more specific, my sql script has 15,000 insert statements and 1 million Update statements.

I'm also thinking along the lines of somehow getting the necessary data exported to a CSV file (instead of as sql statements in a script file), and then loading the data from that CSV into MS Access database.
But I want to do the loading from command line.
If this is possible, is there also a way to specify, database name, table name into which data must be loaded, and a way to mention that the first line in the csv file has the column names.

Thanks!

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial