How to read the data from .accdt file using oledbconnection

[Guest]

Hi,
I want to read the data\content of my .accdt and .accfl files using the
oledb provider of .net 2.0
i've used the below connection string...but it's throwing a unrecognized
database format error...
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Microsoft
Office\Templates\1033\Access\Issues.accdt;Persist Security Info=False;";

Which connectin string shud i specify....is there any otther alternative for
reading these type of files ....please do help me out????

 

[Guest]

Perhaps you will find this helpful...

2007 Office System Driver: Data Connectivity Component
http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thanks for the reply,Tom
I've downloaded the driver...
but still i'm unable to connect to .accdt file thru oledb..

any other alternative

 

[Guest]

I haven't tried it, but I think you need to try connecting to a .accdb file,
not a template file (.accdt). Here is some information from the Access Blog
site regarding the new template format:

"Template files in Access 2007 are a totally new file format based on the
Open Packaging Convention .....Access's old template files used to be .mdb
files renamed with the .mdt extension, but now they are a completely new
format consisting of a hierarchy of zipped up XML and text files."

Reference
http://blogs.msdn.com/access/archive/2007/08/06/access-2007-template-accdt-files.aspx

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________