Running sql script and loading flat file data into MSAccess 2007 database
Posted on 2012-03-28
I have a huge sql script which needs to be executed in MS Access database to load data.
Which is the best way to execute the script given that its close 999MB?
Is there a way to run it from command line? Would that be faster?
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?