Tranfering a textfile into a access table

[odrap]

I need to have the possibility to send an access datatable as attachment of an Email.
Because i do not have MS outlook but only Ms outlook Express,the only way i see to fullfill this goal is using the method DoCmd.SendObject acSendtable, tablename, ... acFormatTxt ...
When we look at the resulting textfile of this method, the textfile lloks like a fixed size delimited text file, but in fact isn't what it looks like.
On the site of the receiver of the email, i try to import this textfile into a table of the same structure as the table the data of the textfile comes from, the result isn't what it has to be. All the data of the textfile is seen as the data of a single field!
Is it possible to transform this texfile in such a way, that it can be imported in a table in the right way?

 

[Galaxiom]

Are you using the fixed width setting on the import? The only way the entire row would import to a single field in this case is if you set the field width to as wide as the entire row.

Redo you import settings.