Avatar billede grind Nybegynder
07. december 2008 - 19:56 Der er 9 kommentarer

Kopiere binære data fra en tabel i Access til excel

Jeg har en tabel hvor nogle billeder fra et tegneprogram gemmes som "Lange binære data". Er der en metode hvor man kan kopiere disse fra en tabel til f.eks et excel regneark og genindlæse dem igen i en tilsvarende tabel i Access?
Avatar billede fdata Forsker
07. december 2008 - 23:41 #1
Hvis du kan eksportere dem i en csv-fil, kan Access spise dem direkte.
Spørgsmålet er bare om de "overlever". Access er "berømt" for at kludre med decimaler.
Avatar billede terry Ekspert
08. december 2008 - 18:24 #2
"...Er der en metode hvor man kan kopiere disse fra en tabel til..."

What table are we talking about? If its is already an Access dB then we do you need
to copy to Excel?

Why do you need to copy to Excel in the first place?
Avatar billede grind Nybegynder
08. december 2008 - 19:03 #3
because I want to send them as a "packet" on email and read them into another database.
Avatar billede terry Ekspert
08. december 2008 - 19:12 #4
so the data is in an Access db and you want to export the data to a file (for example) and then attach the file to an email so that it can later be imported into Access again?
Avatar billede terry Ekspert
08. december 2008 - 19:14 #5
Avatar billede terry Ekspert
08. december 2008 - 19:33 #6
another idea would be to export the data you want to send via email into another accesss dB, rename or zip it an dthen the reciever can easily import from there.
Avatar billede terry Ekspert
07. januar 2009 - 19:35 #7
status?
Avatar billede grind Nybegynder
07. januar 2009 - 23:23 #8
Tery: I make a shop where you can buy "data". Do you know how I can make code for this: A query find the data wich I sell, then i needs to be packed into a seperate file (Access/Excel) and send by mail or downloaded as digital download from the shop. In most cases it needs to be packed as ZIP because Microsoft Email reject it as mdb file. Can you tell me how to code the procedures for making a table from the query and to pack it in ZIP.? I need code in ASP
Avatar billede terry Ekspert
08. januar 2009 - 19:39 #9
Binary data can be stored in Access and also exported to a file which then can be zipped and/or sent in an email.

You can see information on how to do this using VBA in th elink I gave 08/12-2008 19:14:51 but if you can get this to work in ASP I have no idea.

You dont say what "data" you sell so I cant be sure, but actually I would suggest that if the data is very large then I wouldnt keep it in the database but on your web server in a folder. Then Access only stores the link (path/filename) to the file.

But maaybe you might concider placing the question in ASP as I think it may be more relevant there.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester