oledb文本文件的连接字符串 [英] oledb connection string for text file

问题描述

我使用文本文件的连接字符串打开数据库.
喜欢，

Hi,
I open a database using connection string for text file.
like,

con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|;Extended properties='text;HRD=yes;FMT=Delimited'")

并读取一个表(ms访问).发生异常处理错误.

但是表格可以以.txt和.csv文件格式打开

我的问题是使用上述连接字符串格式直接访问数据库中的表

我的前端是vb.net，后端是ms访问.

谢谢U .........

and read a table(ms access). It occur exception handling error arises.

But table can open in .txt and .csv file formats

My problem is to directly access tables in my database with above connection string format

My front end is vb.net and backend is ms access.

Thank U........

推荐答案

您可以使用 http://connectionstrings .com/ [ ^ ]来找到适合您情况的正确连接字符串.

对于 Access 2007 [ ^ ]或访问 [

You can use http://connectionstrings.com/[^] to find the correct connection string for your situation.

For Access 2007[^] or Access[^].

http://www.simongibson.com/intranet/adooledb/


ADO连接字符串

http://www.codemaker.co.uk/it/tips/ado_conn.htm


http://www.simongibson.com/intranet/adooledb/


ADO Connection Strings

这篇关于oledb文本文件的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！