convert non-delimited to delimited

MRAB python at mrabarnett.plus.com
Sat Aug 8 14:14:40 EDT 2009


John wrote:
> I am not really a CS person, but I have a task to import a non-delimited 
> text to an access database.  After some research, I *think* the best way 
> to do this is by first converting the non-delimited text to delimited 
> text, and then import it to the database.  Is this the best way to 
> approach this?  Or is there easier way?
>  
[snip]
> 
> I am really stump on where to go from here.  Any help would be 
> appreciated it.  I have also include a text file which gives several 
> more examples.
> 
You'll need to see what types of file the database can import. A brief
search of the web says that it can import tab-separated text files (a
line is a record and the fields are separated by tab characters).

Be sure to test it first before trying it on the real database! :-)



More information about the Python-list mailing list