[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

Preventing BIFF5 format when using OutputTo ...

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
nico5038
Asked:
nico5038
  • 5
  • 4
1 Solution
 
mgrattanCommented:
Instead of using the OutputTo method, use the docmd.TransferSpreadsheet to create an Excel file or docmd.TransferText to create a text file.
0
 
nico5038Author Commented:
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
 
nico5038Author Commented:
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
mgrattanCommented:
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
 
nico5038Author Commented:
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
 
mgrattanCommented:
That makes me think that it might be a Registry entry---perhaps worthy of further investigation?

Later,

Mike.
0
 
nico5038Author Commented:
Good thinking, they're there in a CLASSES folder !
Gives at least a lead !
0
 
mgrattanCommented:
Way to go Sherlock!  The mystery is afoot!  

Let me know if you get anywhere...I'm curious...
0
 
nico5038Author Commented:
OK dr Watson!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now