"Pivot Man" wrote:

> Hello,
>
> I am trying to use Access for the first time..and not sure if i am doing
> something wrong...or if this is just not the right application for what i am
> trying to do.
>
> I download a report on a nightly basis which contains about 100 rows of data
> and about 20 columns of data.
>
> These are web analytic statistics that track traffic to a website
>
> The columns contain several key metrics (they are the same every day) and
> the rows will contain information on the different sources...google,
> facebook, etc..
>
> The row values will vary from day to day, as will the number of rows.
>
> The columns always remain constant.  Meaning that if the first column will
> always contain vendor name, the second will always contain revenue.
>
> When i set up the database, there is no problem with bringin in the first
> file.  When i try to append anotehr day, i start to have problems.
>
> The exact same file format results in many errors when i try to append.
>
> Here are the errors i received for each fo the lines of appended data..
>
> Error    Field    Row
> Type Conversion Failure    Goal2 Abandoned Funnels    46
> Type Conversion Failure    ID    47
> Null value in an auto-number field    ID    47
>
> Again, i want to stress that it is exactly the same file format, same columns.
>
> Some help would be grealy appreciated.

> Hello,
>
> I am trying to use Access for the first time..and not sure if i am doing
> something wrong...or if this is just not the right application for what i am
> trying to do.
>
> I download a report on a nightly basis which contains about 100 rows of data
> and about 20 columns of data.
>
> These are web analytic statistics that track traffic to a website
>
> The columns contain several key metrics (they are the same every day) and
> the rows will contain information on the different sources...google,
> facebook, etc..
>
> The row values will vary from day to day, as will the number of rows.
>
> The columns always remain constant.  Meaning that if the first column will
> always contain vendor name, the second will always contain revenue.
>
> When i set up the database, there is no problem with bringin in the first
> file.  When i try to append anotehr day, i start to have problems.
>
> The exact same file format results in many errors when i try to append.
>
> Here are the errors i received for each fo the lines of appended data..
>
> Error   Field   Row
> Type Conversion Failure Goal2 Abandoned Funnels 46
> Type Conversion Failure ID      47
> Null value in an auto-number field      ID      47
>
> Again, i want to stress that it is exactly the same file format, same columns.
>
> Some help would be grealy appreciated.