Import text file - how to delimit (noob)

[ern]

I'm new to this, but I need to import some data from a text file into
Excel. I need info a few things:

1. How to delimit the text file so that the information goes into the
spreadsheet "gracefully" (in seperate cells).

2. Perhaps a resource or example illustrating the importing of a text
file into Excel... link?

3. Recommendations on how to script this.... (python possible?)

Thanks for the help !

 

[gimme_this_gimme_that]

If you're using Excel 2003 why don't use use XML and just do file ->
open ?

 

[ern]

If you're using Excel 2003 why don't use use XML and just do file ->
open ?

I've never used XML before. Is there an example of this on the web
somewhere ?

 

[Bruce001]

Here's how I open a text file.

Dim UF As Variant
UF = Application.GetOpenFilename(FileFilter:="Text File
(*.txt),*.txt", Title:="Open input file")
If UF = "False" Then
' user hit cancel'
Exit Sub
End If

Workbooks.OpenText Filename:=U