Re: Insert database rows from CSV file

2005-04-05 Thread Steve Holden
Dennis Lee Bieber wrote: On Mon, 4 Apr 2005 15:54:37 -0700, 3c273 [EMAIL PROTECTED] declaimed the following in comp.lang.python: Thanks for the link, but this is the step I am trying to save (for someone else). Every time he goes to run a report, he must stop and import any new csv files. Since

Re: Insert database rows from CSV file

2005-04-05 Thread 3c273
Dennis Lee Bieber [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 4 Apr 2005 15:54:37 -0700, 3c273 [EMAIL PROTECTED] declaimed the following in comp.lang.python: Thanks for the link, but this is the step I am trying to save (for someone else). Every time he goes to run a

Re: Insert database rows from CSV file

2005-04-05 Thread 3c273
Steve Holden [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dennis Lee Bieber wrote: On Mon, 4 Apr 2005 15:54:37 -0700, 3c273 [EMAIL PROTECTED] declaimed the following in comp.lang.python: Thanks for the link, but this is the step I am trying to save (for someone else).

Insert database rows from CSV file

2005-04-04 Thread 3c273
Hello, I have a really simple Access database table with a format similar to this: CustomerName - ProductOrdered - QtyOrdered I have a CSV file with the appropriate values as follows: Customer1, Widget1, 1000 Customer2, Widget2, 3000 etc I have figured out how to insert the data manually from

Re: Insert database rows from CSV file

2005-04-04 Thread Larry Bates
You may want to take a look at this link. It should be much faster than any programmatic technique. http://www.its.niu.edu/its/CSupport/tipoftheweek/tip_080502.shtml If you still want to do it programmatically, you will need to look at csv module to parse the lines. Larry Bates 3c273 wrote:

Re: Insert database rows from CSV file

2005-04-04 Thread 3c273
Thanks for the link, but this is the step I am trying to save (for someone else). Every time he goes to run a report, he must stop and import any new csv files. Since the files are generated by a Python script, I thought I could just insert them into his table and save him some steps. I'm also