Create Access 2010 File

Hi all. Today I want to hear your suggestions, thoughts and ideas.

I have a need to dump/load information into a access file. I was trying to dynamic create file like FileName_20120126.accdb.

I'm aware to some issues that I come across, while creating access file:

- Unlike xls files, an OLEDB does not create access file automatically. In other words, access file does need to exists so I can dump information;

- This being said, it seems that I have to create some script task (vb.net) to create that file dynamically.

I have some workarounds and solutions. One is, having a access template file with all tables needed, and just dump into that file. But I would like to be able to create access file without that dependancy. 

What do you suggest?

With which version of SQL are you trying to build this?  Are you going the 32-bit or 64-bit route?  Which version of Office do you have installed and are you trying to use the ACE drivers?

I have about an hour later in the day - I'll try to set up a test and see what I can build for this puzzle.

Here's a thread on SQLCentral regarding this.  http://www.sqlservercentral.com/Forums/Topic931754-391-2.aspx

Looks like the Office 2010 components are "in flux" from what I'm finding on the subject.  The 32-bit and 64-bit drivers cannot be installed on the same machine at the same time.   THAT should make it a bit more challenging depending on your development and production environment's versions / components. 

Keith

I can't really check this myself because of my environment.  But can you make a dynamic SQL Statement (with your dynamic name) that is a SELECT ..... INTO dynamicTableName...etc and then execute the SQL Statement?

Keith, we are working with SQL Server x64, office 2010 x64 and about ACE drivers I'm not sure. In the present moment we got a connection with ole db provider Office 12.0.

Daniel, I missed your explanation. Hope my post was clear enough.