Excel to Access- Trouble importing rows of data

[Anonymous]

I'm trying to import a table from Microsoft Excel to Microsoft Access.  I can get it to import a table and row headers but the other data is not importing. My Excel sheet clearly has rows of data in it.  What may be the reasoning for this?

Also, I see in the output it says For input string: "Supervisor- x".  That does come from my table but its just from one of the fields. 

I appreciate any help here.

Thank You,

Ntuttle23

[nivedhitha]

@Ntuttle23 , Can you provide screenshots of your excel input component and the input file? 

[Anonymous]

Yes, here is the input component settings and the input file.

[nivedhitha]

@Ntuttle23 , sorry but I meant the screenshot of the Excel input component. That would be first the first thing to look into as the no of rows coming out of the input component itself is zero. Also the full error message please!

[Anonymous]

Sorry, that was my fault. In the last picture I included the output component  (you asked for the input). There is no error message and it still does create a table and its headers. The problem I'm having is the rest of the data isn't loaded. But here is the output when I execute it:

Starting job excel_to_access at 16:21 03/03/2020.

[statistics] connecting to socket on port 3661
[statistics] connected
For input string: "Supervisor-1"
For input string: "Supervisor-1"
For input string: "Supervisor-1"
For input string: "Supervisor-1"
For input string: "Supervisor-1"
For input string: "Supervisor-1"
For input string: "Supervisor-2"
For input string: "Supervisor-2"
For input string: "Supervisor-2"
For input string: "Supervisor-2"
For input string: "Supervisor-3"
For input string: "Supervisor-3"
For input string: "Supervisor-3"
For input string: "Supervisor-3"
For input string: "Supervisor-3"
For input string: "Supervisor-4"
For input string: "Supervisor-4"
For input string: "Supervisor-4"
For input string: "Supervisor-4"
For input string: "Supervisor-4"
[statistics] disconnected

Job excel_to_access ended at 16:21 03/03/2020. [exit code=0]

[nivedhitha · Accepted solution]

@Ntuttle23 , I'm able to read the same data with the exact same configuration as your input component.

Can you make sure the the data type and the length given in the schema of both components is right and sufficient for the data(mainly the supervisor column.length of it has to be atleast 12) ?

This error occurs mainly because of mismatch in schema

[Anonymous]

Would that be done in Access? If so, I couldn't specify the data type and length because I'm creating a new table when I run the job. Right?

[nivedhitha]

@Ntuttle23 , Yeah when you create it through Talend, you still have to specify the schema.

If you click on edit schema you can see what the data type and length are for these columns

[Anonymous]

Im going to assume that was the issue. I started from a clean slate and bumped the character length up a little bit this time. It worked! I appreciate your help