Rx_
Nothing In Moderation
- Local time
- Today, 00:25
- Joined
- Oct 22, 2009
- Messages
- 2,803
Can anyone suggest any ideas as to why this would be causing errors?
For a few months, a copy of a Spreadsheet named ProjectSummary has been transferred to a local Access table for use in query operations.
Recently it was noticed that an ProjectSummaryS_ImportErrors table began to appear.
This is the code:
This is the error:
The first 36 are OK
ProjectSummary$_ImportErrors Error Field Row
Type Conversion Failure Task Number 36
Type Conversion Failure Task Name 36
Type Conversion Failure Task Number 37
Type Conversion Failure Task Name 37
Type Conversion Failure Task Number 38
.... this continues for hundreds of rows
In the local access Table ProjectSummary, the TASK Number is a type Short Text (255, format @
The Same for the Task Name column
On the spreadsheet, the Task Number and Task Name up to row 35 are numbers such as 3715 (for each column).
On the row the error begins the data is like:
000307-2 and ABC Open Construction
It would seem as if the Text of 255 would work for the text.
Lucky, these columns are not actually needed for the data analysis.
However, this process runs many times a day so the error tables are just piling up.
000307-2
For a few months, a copy of a Spreadsheet named ProjectSummary has been transferred to a local Access table for use in query operations.
Recently it was noticed that an ProjectSummaryS_ImportErrors table began to appear.
This is the code:
Code:
DoCmd.TransferSpreadsheet _
acImport, _
acSpreadsheetTypeExcel5, _
"ProjectSummary", _
Myfullname, _
True, _
WorksheetInvIssName & "!"
The first 36 are OK
ProjectSummary$_ImportErrors Error Field Row
Type Conversion Failure Task Number 36
Type Conversion Failure Task Name 36
Type Conversion Failure Task Number 37
Type Conversion Failure Task Name 37
Type Conversion Failure Task Number 38
.... this continues for hundreds of rows
In the local access Table ProjectSummary, the TASK Number is a type Short Text (255, format @
The Same for the Task Name column
On the spreadsheet, the Task Number and Task Name up to row 35 are numbers such as 3715 (for each column).
On the row the error begins the data is like:
000307-2 and ABC Open Construction
It would seem as if the Text of 255 would work for the text.
Lucky, these columns are not actually needed for the data analysis.
However, this process runs many times a day so the error tables are just piling up.
000307-2