I have an MFC applicaiton where I connect to a dbf file using ado and
then get a recorcset from this file. All works fine. What I then do is
I create another dbf table by using CREATE Table ddl statement in the
recordset open method. It creates a table just fine, however if the
table name specified is longer than 8 characters is will truncate to 8
characters. Anyway around this? I am importing msado15.dll into my MFC
app.
Re: Creating dbf table using ADO Recordset open method ... table name specified is longer than 8 characters is will truncate to 8 ... Since then other version of "xBase" have appeared, ... It also depends on the tool you plan to use the .dbf file - obviously if it ... what version of ADO you are using, ... (microsoft.public.data.ado)
Linking DBF files and the filename length ... and when I try to link to a DBF file with a name longer ... If I change the DBF filename to 8 characters or less the file will link ... filenames (but I cant remember). ... (microsoft.public.access.externaldata)
Re: .dbf file import problems ... You have to use DOS 8.3 file names for dBase files.... the column names in the file have to be 10 characters or less with no ...Access MVP... >I have a .dbf file that I am trying to import to Access. ... (microsoft.public.access.externaldata)
Re: CSV --> EXCEL --> DBASE III with Visual Basic 6 ... For example a columname called adress in CSV file after converting into a ...DBF file the adresses is been cut to 11 chracters. ... Table/Column names in xBase are limited in length. ... limited to 8 characters. ... (microsoft.public.vb.database)
Jet database engine could not find the object <error> ? ... I hit the same error when I was trying to use java's JDBC-ODBC bridge... to connect to a DBF file.... I changed my file name from 12 characters... (microsoft.public.access.conversion)
