Prev: Access 97 and 2007 on the same machine
Next: Combo Box/Relationship Help
From: John W. Vinson on 6 May 2010 18:13
On Thu, 6 May 2010 16:23:04 -0400, "Steve" <notmyemail(a)address.com> wrote:

>Try exporting your file with a .mdb extension then renaming the file to a
>.dbf file. Put the following code after your DiCmd.TransferDatabase command:

Good Lord, Steve.

That's like putting a Chrysler hood ornament on a Toyota Camry and assuming it
will become one. .mdb and .dbf files have utterly different structures.
--

John W. Vinson [MVP]
From: John W. Vinson on 6 May 2010 18:15
On Thu, 6 May 2010 13:03:01 -0700, FedWerkker
<FedWerkker(a)discussions.microsoft.com> wrote:

>I was thinking this should be simple. I want to copy, transfer or whatever
>the TBS Table in the VPS_TBS.mdb database and send it to our shared drive,
>but have the file be a .dbf file.
>
>I tried the F1 Help
>
>DoCmd.TransferDatabase acExport, "DBASE III",
> ' "C:\@CDATA\VP_tbs.mdb", acTable, "tbs", _
> ' "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.dbf"
>
>I've tried this in a Macro, and in code, but ways fails. The error tells me
>the path doesn't exist, but that is the path. Does anyone see any obvious
>errors. If you know a of way (right click, Exprort, save as, choose where
>works fine, but I'd like to get in code if possible.

dBase is very picky about 8 character fieldnames. Try exporting to a C: folder
with a folder name of 8 alphanumeric characters or fewer.
--

John W. Vinson [MVP]
From: david on 7 May 2010 06:59
Perhaps you don't think that just changing the file extension
will make the export work, but it is a reasonable suggestion.

For example, suppose you were trying to export a .RTF
file using:

DoCmd.TransferText acExportMerge, , "tblMerge",
"C:\CodeProgrammes\Merge1.doc

That won't work, and the solution is to

>> Try exporting your file with a .TXT extension then renaming the file
>> ..DOC file. Put the following code after your DiCmd.TransferTEXT
>>
>> Dim OldName, NewName
>> OldName = "K:\CPANALYSIS\VP\Access\DBASE\tbs1.TXT"
>> NewName = "K:\CPANALYSIS\VP\Access\DBASE\tbs1.DOC"
>> Name OldName As NewName


However, in this case, I think it is the 8 character export folder
problem, rather than the file extension problem.

(david)


"KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message
news:9344E688-966E-421C-9251-04FF41AC6B0B(a)microsoft.com...
>I do not think that just changing a file extension from .mdb to .dbf will
> make it work as a dBaseIII database.
>
> --
> Build a little, test a little.
>
>
> "Steve" wrote:
>
>> Hello Bill,
>>
>> Try exporting your file with a .mdb extension then renaming the file to a
>> ..dbf file. Put the following code after your DiCmd.TransferDatabase
>> command:
>>
>> Dim OldName, NewName
>> OldName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.mdb"
>> NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.dbf"
>> Name OldName As NewName
>>
>> Steve
>> santus(a)penn.com
>>
>> "FedWerkker" <FedWerkker(a)discussions.microsoft.com> wrote in message
>> news:80E9D87C-6A91-4C73-B94C-E3C2E4B040BE(a)microsoft.com...
>> >I was thinking this should be simple. I want to copy, transfer or
>> >whatever
>> > the TBS Table in the VPS_TBS.mdb database and send it to our shared
>> > drive,
>> > but have the file be a .dbf file.
>> >
>> > I tried the F1 Help
>> >
>> > DoCmd.TransferDatabase acExport, "DBASE III",
>> > ' "C:\@CDATA\VP_tbs.mdb", acTable, "tbs", _
>> > ' "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.dbf"
>> >
>> > I've tried this in a Macro, and in code, but ways fails. The error
>> > tells
>> > me
>> > the path doesn't exist, but that is the path. Does anyone see any
>> > obvious
>> > errors. If you know a of way (right click, Exprort, save as, choose
>> > where
>> > works fine, but I'd like to get in code if possible.
>> >
>> > MS Access 97:
>> >
>> > thanks
>> > Bill
>> > --
>> > FedWerkker
>>
>>
>> .
>>


From: Steve on 7 May 2010 19:46
Good Loord, John.

You are such an ignoramus!!!! You think you know it all and that gives you
the right to be insulting to other people.

See David's response. My suggestion may not work but is reasonable to give
it a try. The OP's TransferDatabase statement exports his table as a DBase
III file so it can be saved with any extension including .mdb.

You are nothing but a hypocrite!!! You condone the conduct of visio john and
arno r but have a hair trigger to criticize me. That is one hundrd eighty
degrees oposite of the conduct expected of an mvp.

Steve



"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:plf6u5ti2a1pd42451ruutdfqmhjgddv4s(a)4ax.com...
> On Thu, 6 May 2010 16:23:04 -0400, "Steve" <notmyemail(a)address.com> wrote:
>
>>Try exporting your file with a .mdb extension then renaming the file to a
>>.dbf file. Put the following code after your DiCmd.TransferDatabase
>>command:
>
> Good Lord, Steve.
>
> That's like putting a Chrysler hood ornament on a Toyota Camry and
> assuming it
> will become one. .mdb and .dbf files have utterly different structures.
> --
>
> John W. Vinson [MVP]


First  |  Prev  | 
Pages: 1 2
Prev: Access 97 and 2007 on the same machine
Next: Combo Box/Relationship Help