Access 2013 - Dbase (.dbf) Table Import option

I'll try to create a function that imports .dbf to new access table.

Dear friend,

I'm not an expert in Ms Access. But I'll explain to you of what I only know.

In ms access, there is a way to manipulate files .csv, .xls, .mdb, etc. not by using wizard, but by coding (programmatically) in VBA (Code Builder). I used this code below to connect and throw sql commands to .dbf files (could be DDL or DML you can check visual foxpro reference to sql commands it supports)

You can start with this and take a first stab:

    'You can run this without referencing ADO Library

    Dim cn As Object

    Dim rs As Object

    Dim strSql As String

    Dim strConnection As String

    Set cn = CreateObject("ADODB.Connection")

    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

        "Data Source=C:\YourDir_thatcontains_dbf_files\;" & _

        "Extended Properties=dBase IV"

    strSql = "SELECT [COL1],[COL_ETC] FROM DBF_TABLE"      'do not include extension name

    cn.Open strConnection

    Set rs = cn.Execute(strSql)

    While Not rs.EOF

      Debug.Print rs.Fields("COL1").Value & vbTab & rs.Fields("COL_ETC").Value

      'Or do somethin else you need to do

      rs.MoveNext

    Wend

    rs.Close

    Set rs = Nothing

    cn.Close

    Set cn = Nothing

Thanks! I got excited of what you've said. 

Actually I got the idea in importing/manipulating .csv, .xls , etc using ADO Library in VBA.

Then I thought that would it be possible also in .dbf coz ODBC supports dBase files/ vfpTables. 

So i just changed the connection string used in importing/manipulating other filetypes by just using this one I searched in Google (sorry I seldom use Bing. :D)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YouDir_thatcontains_dbf_files\;Extended Properties=dBase IV;

Someone must create a library that executes DDL/DML compatible with VisualFoxPro sql commands. I don't know, I'm just hypothesizing. Hahah :D

Please elaborate further. What exactly do you mean?