Solved

Preventing BIFF5 format when using OutputTo ...

Posted on 2000-04-17
9
419 Views
Last Modified: 2008-03-17
I'm using DOCMD.OUTPUTTO to export a table to an excel spreadsheet.
When looking at the sheet it's formatted in the so-called Biff5 format. This format proves to be the defailt also when doing a copy/paste from a datasheet/table from access (2000 and 97) to an opened Excel sheet.

Question: Can I set the default (outputto and copy/paste) format to plain text ?!
0
Comment
Question by:nico5038
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 14

Accepted Solution

by:
mgrattan earned 100 total points
ID: 2723785
Instead of using the OutputTo method, use the docmd.TransferSpreadsheet to create an Excel file or docmd.TransferText to create a text file.
0
 
LVL 54

Author Comment

by:nico5038
ID: 2723873
I'll try that right away , knowing you that will solve the problem of the "output to excel problem"!

But is it also possible to get rid of this format when using the copy/paste?
I know/use the "paste special" solution, but I would like to change the default to text, just being able to use the shortcut keys and getting rid of the extra paste-special-form.

I must say that I had never heard of the BIFF5 format before.
0
 
LVL 54

Author Comment

by:nico5038
ID: 2757298
docmd.TransferSpreadsheet did the trick to avoid the BIFF5 format.

Still puzzled about how to get rid of it when using ctrl-C and ctrl-V.

0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 14

Expert Comment

by:mgrattan
ID: 2757449
Nico,

Sorry buddy, I don't know of a good way to get the standard Copy/Paste functionality to generate straight text into Excel instead of BIFF5 format.

I'm thinking that it might be possible to use Windows API calls to handle the clipboard but that is probably overkill for a minor (in my opinion) problem.

Anyway, glad the TransferSpreadsheet and TransferText commands are working for you.

Regards,
Mike
0
 
LVL 54

Author Comment

by:nico5038
ID: 2757512
The fact that BIFF5 is showed (when using PASTE SPECIAL) in a listbox gave me the feeling it's determined somewhere from .dll's or other drivers, could however find no place to manipulate the contents of that listbox, nor the possibility to set a default.

It's not only to Excel but also to Word that the BIFF5 format is used, so it's known by the clipboard and ctrl+C takes it probably as default as it's the first entry in that Paste Special listbox.

But well, we can live with it as with so many other odd things.

See you !

Nico
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2757601
That makes me think that it might be a Registry entry---perhaps worthy of further investigation?

Later,

Mike.
0
 
LVL 54

Author Comment

by:nico5038
ID: 2758296
Good thinking, they're there in a CLASSES folder !
Gives at least a lead !
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2766301
Way to go Sherlock!  The mystery is afoot!  

Let me know if you get anywhere...I'm curious...
0
 
LVL 54

Author Comment

by:nico5038
ID: 2766723
OK dr Watson!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access Trouble With Grouping and Suming Query Results 6 55
Handle Apostrophes in SQL Parameter 16 67
SUBFORM on ACCESS 2013 8 33
Batch convert csv to xlsx 10 55
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question