I m trying to import file from txt format to access database by using Macros,

Want to transfer in delimitted (space) format, file is getting uploaded but without seperation i.e all field are appearing in single field.

Can somebody help me with specification Name or let me know from where i can get it.