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?
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.
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?
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.
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
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.
Synes godt om
Ny brugerNybegynder
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.