472,353 Members | 1,193 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Biff clipboard format - what do we need it for ?

dima69
181 Expert 100+
Biff format is defined as default format for copying data from Access to Excel (under registry key ...\Access\Clipboard Formats). This format has a known problem as numbers are pasted as text using Access 2002 with Excel 2002. So M$ suggest using older Biff5 format (from Office 2000) instead of Biff8.
But Biff5 has a problem too. Numbers from fields with input mask set are pasted in Excel as text, if you copy the record (not one field).
On the other hand, I've seen no problem pasting from Access to Excel in HTML or Text format (using paste special).
So I am considering to just erase that Biff format definition during application installation, that way HTML becomes default.

My question - is there any reason why I should't do that ?
Jan 18 '07 #1
6 7741
nico5038
3,080 Expert 2GB
Can't think of any, the BIFF format did annoy me too :-)

Nic;o)
Jan 18 '07 #2
NeoPa
32,511 Expert Mod 16PB
If data is converted to text as part of the transfer this may confuse Excel.
Excel is very particular about data being numeric or text.
Many people get confused over this. Sometimes data is a string of numeric digits; sometimes simply a number; sometimes a number but formatted to look like it could be a string.
If transferring as text loses this info then I'd be wary of it.
Jan 19 '07 #3
dima69
181 Expert 100+
If data is converted to text as part of the transfer this may confuse Excel.
Excel is very particular about data being numeric or text.
Many people get confused over this. Sometimes data is a string of numeric digits; sometimes simply a number; sometimes a number but formatted to look like it could be a string.
If transferring as text loses this info then I'd be wary of it.
Seems like when pasting data as text, Excel automatically recognizes data types, just as it does when typing the data in. So as far as I see this is not a problem.
Jan 19 '07 #4
NeoPa
32,511 Expert Mod 16PB
That IS the problem.
Consider string data which contains only digits?
Excel is prone to decide, on your behalf, that you don't want string data but numeric data. This can confuse the inexperienced no end. Trust me I have spent a lot of time fixing these problems for my users.
Jan 19 '07 #5
dima69
181 Expert 100+
That IS the problem.
Consider string data which contains only digits?
Excel is prone to decide, on your behalf, that you don't want string data but numeric data. This can confuse the inexperienced no end. Trust me I have spent a lot of time fixing these problems for my users.
Ok, maybe it is a problem. But you must agree that having strings interpreted as numbers is much better than having numbers interpreted as text :)
And how do you get out of all this mess anyway ?
Jan 19 '07 #6
NeoPa
32,511 Expert Mod 16PB
I can't claim to be a great expert in this area I'm afraid. I just chipped in with something I've learned from experience. If you can find a method that doesn't cause you any problems you're sorted ;) You know your data better than ... well anyone else hopefully.
Personally I get my Excel spreadsheet to query the database directly, but my situation is probably different from yours in many ways. That's an option of course, but you need to find the method that suits you (your data) best.
Jan 19 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: LG | last post by:
Just have a question with regards to the clipboard, and how to read what other applications (Adobe InDesignCS) place in the clipboard. I am...
2
by: Gey-Hong Gweon | last post by:
Is there a way to copy a PIL image to windows clipboard (as a dib image or a bitmap, I suppose)? What I would like to accomplish is to do a fast...
1
by: emma middlebrook | last post by:
Hi Needed a title like that to get you reading :-) Having never programmed for the Clipboard before, I expected it to work as follows:...
3
by: Jon Brookins | last post by:
I'm reposting this question as the other post seems to have been sucked into the net black hole. I'll keep this short. I am trying to read and...
2
by: fred | last post by:
I am trying to Copy and paste using a custom format but I canot retrieve the data. In the main Form's class I have declared: Dim myDocmanFormat...
7
by: lgbjr | last post by:
Hello All, Im using a context menu associated with some pictureboxes to provide copy/paste functionality. Copying the image to the clipboard...
11
by: Andrey Dzizenko | last post by:
Hi all! Did anyone try the subj? I use extern IsClipboardFormatAvailable and GetClipboardData from user32.dll....
3
by: ggupta78 | last post by:
Hi, Currently in our application we use the MHTML way of exporting to Excel i.e we render the datagrid HTML and set the MIME type to Excel. This...
5
by: exhuma.twn | last post by:
As many might know, windows allows to copy an image into the clipboard by pressing the "Print Screen" button on the keyboard. Is it possible to...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.