topic Re: Excel to Access- Trouble importing rows of data in Talend Studio

Excel to Access- Trouble importing rows of data

Anonymous — Tue, 03 Mar 2020 14:45:46 GMT

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

Re: Excel to Access- Trouble importing rows of data

nivedhitha — Tue, 03 Mar 2020 20:36:41 GMT

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

Re: Excel to Access- Trouble importing rows of data

Anonymous — Tue, 03 Mar 2020 21:11:37 GMT

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

Re: Excel to Access- Trouble importing rows of data

nivedhitha — Tue, 03 Mar 2020 21:19:26 GMT

@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!

Re: Excel to Access- Trouble importing rows of data

Anonymous — Tue, 03 Mar 2020 21:26:57 GMT

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]

Re: Excel to Access- Trouble importing rows of data

nivedhitha — Tue, 03 Mar 2020 22:05:21 GMT

@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

Re: Excel to Access- Trouble importing rows of data

Anonymous — Tue, 03 Mar 2020 22:39:29 GMT

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?

Re: Excel to Access- Trouble importing rows of data

nivedhitha — Wed, 04 Mar 2020 21:05:26 GMT

@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

Re: Excel to Access- Trouble importing rows of data

Anonymous — Wed, 04 Mar 2020 21:26:57 GMT

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