Need help, urgent..

[Zero_boy07]

Hi, i need to import some data from excel to access, but when i do this i
loose the format of one column, and i need to keep this format.
The ype of data is text on excel and memo on access.

 

[Ken Snell [MVP]]

When you say "lose the format", do you mean the import process is truncating
the text string from EXCEL into ACCESS? If yes, use a macro to do the
import, using the TransferText action to do the import. See help files for
more info.

 

[Zero_boy07]

I have some information with tabs, spaces and enters, when i import it to
access it lose those formats, and i need to keep those.
All the info stays the same, the tabs, enters, and some spaces get lose.

 

[Ken Snell [MVP]]

Ahhh... that is more difficult. EXCEL uses a different character for a line
feed compared to ACCESS, for example.

All you'll be able to do here is to import the data to ACCESS, then run
update queries on the data to convert the characters that EXCEL uses to the
ones that ACCESS uses.

For example, EXCEL uses Chr(10) for a line feed; ACCESS uses the combination
of Chr(13) and Chr(10) ( Chr(13) & Chr(10) ) for the same result.

 

[Zero_boy07]

Ok, does anyone have a VB function that can help me to do this change?.
I still need to keep the format of the info in each record.

 

[Ken Snell [MVP]]

No, I am unaware of any "do all" function. You may need to write your own
function(s) to do this.