Daily download

[Pivot Man]

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.

 

[golfinray]

Type conversion errors usually means you are trying to bring text into a
field where numbers are specified or numbers into a text field, dates into
number fields, etc. Check the datatypes. You must also have an autonumber
field that is blank or null which is not allowed.

 

[troy23]

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 iam
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.

Can you import it into a new table? It looks like Access is having
trouble with data conversion here due to data types.

For total MS Access mastery
http://access-databases.com/ms-access-tutorial/