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