Discussion:
Docmd.TransferDatabase acExport file name problem
(too old to reply)
Sunny
2009-04-07 20:55:28 UTC
Permalink
Windows XP SP2
Access 2007

I am trying to export query results to dbase 5.0 format. It exports fine but
somehoe it truncates the file name to 8 charaters. It used to work fine but
since I changed the computer I am having this probleb. Can anyone please
help me?
Here is my syntax:

DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path, acTable,
"myTable", "LongDBFFileName.dbf"

It creates the export and save as LongDBFF.DBF
Alex Dybenko
2009-04-08 09:34:12 UTC
Permalink
Hi,
yes, this is a limitation of dbase isam driver, but you can first export to
a short name and then rename the file using Name statement
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Post by Sunny
Windows XP SP2
Access 2007
I am trying to export query results to dbase 5.0 format. It exports fine
but somehoe it truncates the file name to 8 charaters. It used to work
fine but since I changed the computer I am having this probleb. Can anyone
please help me?
DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"
It creates the export and save as LongDBFF.DBF
Sunny
2009-04-08 14:17:45 UTC
Permalink
But it used to work fine for 5 years and still working ok on old m/c with
windows xp and access 2007. We got new m/c last month and since then we are
having problem. I am thinking this has to do something with odbc drive came
with the m/c., but I dont know how to check and what to check?
Post by Alex Dybenko
Hi,
yes, this is a limitation of dbase isam driver, but you can first export
to a short name and then rename the file using Name statement
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Post by Sunny
Windows XP SP2
Access 2007
I am trying to export query results to dbase 5.0 format. It exports fine
but somehoe it truncates the file name to 8 charaters. It used to work
fine but since I changed the computer I am having this probleb. Can
anyone please help me?
DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"
It creates the export and save as LongDBFF.DBF
Alex Dybenko
2009-04-09 09:52:11 UTC
Permalink
Hi,
Hmm, I don't know, but since access 97 till 2007 I never managed to export
to long name DBF. I used only dbase III format, this could be a reason, but
on other hand - ISAM driver is the same for all DBF formats. Try to compare
ISAM driver (Msxbde40.dll) versions
Look here also http://support.microsoft.com/default.aspx/kb/230125
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Post by Sunny
But it used to work fine for 5 years and still working ok on old m/c with
windows xp and access 2007. We got new m/c last month and since then we
are having problem. I am thinking this has to do something with odbc drive
came with the m/c., but I dont know how to check and what to check?
Post by Alex Dybenko
Hi,
yes, this is a limitation of dbase isam driver, but you can first export
to a short name and then rename the file using Name statement
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Post by Sunny
Windows XP SP2
Access 2007
I am trying to export query results to dbase 5.0 format. It exports fine
but somehoe it truncates the file name to 8 charaters. It used to work
fine but since I changed the computer I am having this probleb. Can
anyone please help me?
DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"
It creates the export and save as LongDBFF.DBF
NICOLHOLAS JAMES BEGGS
2009-04-23 20:15:47 UTC
Permalink
im SPER TO IN LONDO WE DO IN AT ON TIME ON AT BASICES IN AT COLLICE AND TICE
IN AT SOMONE WE RAE IN TO DE IN THURROCK WE AT SOMSON IN NICOLAS JAMES BEGGS
109 MOLLAND LINE SUTH OCKOND IN ESSEX
Post by Sunny
Windows XP SP2
Access 2007
I am trying to export query results to dbase 5.0 format. ECT It exports
fine but somehoe it truncates the file name to 8 charaters. It used to
work fine but since I changed the computer I am having this probleb. Can
anyone please help me?
DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"
It creates the export and save as LongDBFF.DBF
Oliver Twinberrow
2009-06-26 10:44:02 UTC
Permalink
Post by Sunny
Windows XP SP2
Access 2007
I am trying to export query results to dbase 5.0 format. It exports fine
but somehoe it truncates the file name to 8 charaters. It used to work
fine but since I changed the computer I am having this probleb. Can anyone
please help me?
DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"
It creates the export and save as LongDBFF.DBF
Loading...