Migrating Information from Access to Excel

[pablavo]

Hi there,

I've got a question I hope someone can help me with.

Basically, I have a field in Access that allows 90 characters. I want to move the data in this field to Excel. However, the field has to be broken up in to three fields in Excel. so that some characters are in one field and so on.

It would work in the principle that the first cell in Excel would hold 40 characters, the second, 25 and then the last field 25.

There is another condition, if there is a way to break the fields data up so that it populates three Excel cells, it would have to do so so that it didn't break up words. Only the spaces between the words would be divided into cells.

Does anyone know of a function?

The only other way I can think of doing this is by providing three fields in Access so that it can be broken up there and then it would be ready to migrate into Excel three cells.


Thanks

 

[Brianwarnock]

I would do the parsing in Access, probably insert a special character at the point of split and then use the Split function in Excel.
This needs clarifying

It would work in the principle that the first cell in Excel would hold 40 characters, the second, 25 and then the last field 25.

There is another condition, if there is a way to break the fields data up so that it populates three Excel cells, it would have to do so so that it didn't break up words. Only the spaces between the words would be divided into cells

.

but assuming 40 is the max in the first cell and 25 in the second with the rest in the 3rd then using Instrrev, mid. len etc should enable you to achieve your aims in a function.

Brian

 

[pablavo]

Thanks Brian, I'll look into that.

users will be typing into the field a lot and they want the easiest way of migrating that data into Excel without having to do much work themselves if you know what I mean

Thanks