If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Update Table - stevie PIMPS again!
You are an ignoramus, Karl. You think you know it all and that gives you the
right to act as an ignoramus. Look at the microsoft.public.access OP's post again. His file is being exported as a DBase III file. My suggestion merely says to save it with a ..mdb extension and then change the extension to .dbf. You ought to be nominated for MVP Visio and then you would be as ignorant as visio john. Steve "KARL DEWEY" wrote in message ... See where Steve says to rename a file from .mdb to .dbf to make it a dBase III file. Subject: Export an Access Table as an dbase III file 5/6/2010 1:55 PM PST By: Steve In: microsoft.public.access 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.md b" NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.db f" Name OldName As NewName Steve http://www.microsoft.com/communities...&lang=en&cr=US -- Build a little, test a little. "John... Visio MVP" wrote: "Steve" wrote in message ... Rob, If you get this to work for you manually, I could automate it for you so you click a button on your end and then your users click a button on their end. I provide fee-based help with Access applications. There would be a small fee to automate this for you. Contact me if you want it automated. Steve Stevie, if you were any good, you would have repeat customers that would keep you busy. Pimping your services in a free support venue also shows that you have no ethics and are definitely not someone to trust. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP . |
|
Thread Tools | |
Display Modes | |
|
|