Send Object

[nonrev]

Hi,

I've created a simple db to maintain records of client requests. I duplicated and modified it some for a client that makes multiple requests. My intention was for the client to send me the requests via e-mail and permit me to easily import the resulting attachment into my main db. I wrote a macro to send object from the client db and got it to work as an .xls attachment and wrote a macro that successfully imported it into mine. The problem is that I have a couple of memo fields that are being truncated. Can anyone suggest a remedy or even a more efficient method? I've not been successful at all when attempting to use .txt or .htm formats. Both myself and the client have Access and Excel 2002. TIA Chris

 

[yellow]

Do you know why these memo fields are being truncated? How many characters are in these fields, thousands?

 

[nonrev1]

truncation

I thought it was being truncated due to Excel's character limitation but I'm not sure. There are not thousands.... maybe a hundred or 2 at the most.

 

[yellow]

Sorry just re-reading your original post. You are trying to get data from one database to your database. You are exporting this data as an Excel spreadhsset then importing it in to yours, correct?

From a personal point of view I don't think Excel and Access 'get on' when it comes to importing files. So I try to use text files.

Excel can have 32,767 characters in a cell, so this should be enough room for your text! When it's exported is all the data in the Excel sheet?

Are your fields in Access definately set up as Memo fields and not text fields?

There are so many reasons why it could be doing this so it's difficult to answer without more information.