Mark Martin wrote:
I'm pulling my hair out trying to find out how to upload this data. My files can
vary in numbers of rows and column
Fix this first. Your CSV file is not ready for a database.
Develop a meaningful data struture, probably involving multiple table, since that is
usually
I'm pulling my hair out trying to find out how to upload this data. My files can vary
in numbers of rows and columns but the x and y axis always contain the same type of
metadata - in my case cost centre and cost item. A sample of the data would look like :
On Feb 4, 2004, at 6:50 AM, Mark Martin wrote:
I'm pulling my hair out trying to find out how to upload this data. My
files can vary in numbers of rows and columns but the x and y axis
always contain the same type of metadata - in my case cost centre and
cost item. A sample of the data would
On Feb 4, 2004, at 6:50 AM, Mark Martin wrote:
I'm pulling my hair out trying to find out how to upload this data. My
files can vary in numbers of rows and columns but the x and y axis
always contain the same type of metadata - in my case cost centre and
cost item. A sample of the
(row 0 values) = blahblah
Mark
- Original Message -
From: James Edward Gray II [EMAIL PROTECTED]
To: Mark Martin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 2:34 PM
Subject: Re: Uploading a CSV file to a Database Table
On Feb 4, 2004, at 6:50 AM, Mark
On Feb 4, 2004, at 11:24 AM, Mark Martin wrote:
hmmm..bit over my head I'm afraid.
What was over you head? What I showed, or building an SQL statement
and feeding it to the DBI?
I've tried a different tack that maybe you can help me with. It's quite
possible that I will be forced to take
