Share via

Linking a Access report from excel table

Anonymous
2016-02-03T18:58:22+00:00

I am very new to Access, so be nice...I am trying to auto populate a report from a database created in excel. I linked the excel file to the table where the report is pulling the source data from and only a few of my attributes are filling in on the report. All the field names in the excel file match those in the Access table. I wasn't sure if the field formatting (general, Number, Date) had to equal that in the access database in order for it to work. Anyone have any suggestions?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-03T21:36:47+00:00
    1. The Recordsource is set to the Excel Table. 

    I suggest using a query of the table as record source for the report.

    Run the query to see if the data flows.    If so, then check control source of the report controls.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2016-02-03T20:41:02+00:00

    Ok, some more clarification on terms. You don't have fields on a form or report. You have Controls that may or may not be bound to a field in a table. This is a subtle but important distinction.

    So if the Excel data is not showing up in the report on the Control, the next question becomes what is the Controlsource of those controls. The most probable explanation is that the controls are not properly bound to the fields in the Recordsource.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-02-03T19:46:05+00:00

    Thank you for the clarification.

    1. I linked the excel table as a table object. 
    2. Yes, the excel data is not showing up in its corresponding field within the report
    3. The Recordsource is set to the Excel Table.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-02-03T19:16:33+00:00

    I linked the excel file to the table where the report is pulling the source data from and only a few of my attributes are filling in on the report. All the field names in the excel file match those in the Access table. I wasn't sure if the field formatting (general, Number, Date) had to equal that in the access database in order for it to work.                

    How did you do the linking of Excel to an existing table?    My Access link options are to Append to existing table, create a new table, or create a linked table that has the Excel data but NO EXISTING data.

    Was this answer helpful?

    0 comments
  5. ScottGem 68,830 Reputation points Volunteer Moderator
    2016-02-03T19:14:43+00:00

    First, you don't "link the Excel file to the table". You either link an Excel table as a table object in Access or you import the data into an Access table object. So which are you doing?

    Second, are you saying the data in the Excel table is not showing in the report?

    Finally. what is the Recordsource of the report?

    Was this answer helpful?

    0 comments