Home

import data from access to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-754001%22%20slang%3D%22en-US%22%3Eimport%20data%20from%20access%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754001%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Econtingency%20table%20in%20excel%20from%20external%20access%20database%3C%2FSPAN%3E%3C%2FSPAN%3E.%20When%20I%20created%20first%20table%2C%20it%20is%20working%20but%20when%20I%20want%20to%20create%20second%20table%2C%20it%20tells%20me%20that%20in%20access%20database%20are%20no%20table%20for%20import.%3C%2FP%3E%3CP%3EStrange%20is%2C%20when%20I%20have%20in%20access%20database%20connected%20excel%20sheet%20I%20am%20able%20to%20create%20all%20tables%2C%20but%20when%20I%20have%20connected%20txt%20in%20access%2C%20so%20is%20posible%20to%20create%20only%20one%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Econtingency%20table%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754468%22%20slang%3D%22en-US%22%3ERe%3A%20import%20data%20from%20access%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754468%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376108%22%20target%3D%22_blank%22%3E%40jirikoci%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20question%20has%20not%20received%20any%20replies%20so%20far%2C%20so%20I'm%20trying%20to%20help%20you%20out.%20Your%20question%20is%20not%20very%20clear.%20You%20say%20you%20are%20%22%3CSPAN%3Etrying%20to%20create%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Econtingency%20table%20in%20excel%20from%20external%20access%20database%3C%2FSPAN%3E%3C%2FSPAN%3E%22.%20What%20does%20that%20mean%3F%20What%20steps%20are%20you%20taking%3F%20In%20Excel%3F%20In%20Access%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20the%20%22first%20table%22%20and%20how%20did%20you%20create%20it%3F%20What%20is%20the%20%22second%20table%22%20and%20how%20did%20you%20created%20it%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20also%20don't%20understand%20your%20references%20to%20connect%20to%20txt%20in%20Access.%20Please%20provide%20more%20details.%20A%20few%20screenshots%20would%20help%20to%20illustrate%20what%20you%20are%20doing%2C%20and%20maybe%20you%20could%20put%20into%20words%20what%20you%20are%20trying%20to%20achieve.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20using%20Power%20Query%20to%20connect%20to%20Access%3F%20If%20not%2C%20why%20not%3F%20Power%20Query%20is%20the%20BEST%20way%20to%20connect%20to%20ANY%20data%20source%20from%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754820%22%20slang%3D%22en-US%22%3ERe%3A%20import%20data%20from%20access%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eat%20first%20I%20am%20beginner%20in%20Access%20I%20learning%20by%20myslef.%20I%20will%20try%20to%20explain%20better%20%3A).%3C%2FP%3E%3CP%3EI%20have%20Access%20database%2C%20where%20I%20have%20some%20tables%20whit%20basic%20data%20and%20linked%20excel%20file%20(see%20picture%20capture%201a)%2C%20which%20is%20changing%20every%20day.%20Next%20I%20have%20created%20queries%20for%20future%20work.%3C%2FP%3E%3CP%3EWhen%20I%20want%20to%20create%20contingency%20tables%20in%20excel%2C%20is%20no%20problem%20to%20create%202%20or%20more%20of%20them%20when%20linked%20file%20in%20access%20is%20excel%20(see%20picture%20capture%201b).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20I%20need%20to%20link%20txt%20file%20to%20access%20database%20(see%20picture%20capture%202a)%2C%20because%20it%20is%20original%20format%20of%20file.%20In%20access%20everything%20working%20like%20with%20linked%20excel%20file.%20The%20problem%20is%20when%20I%20want%20to%20create%202%20or%20more%20contingency%20tables%20in%20excel.%20I%20am%20able%20to%20create%20first%20one%20and%20when%20I%20want%20to%20create%20second%20one%2C%20I%20received%20message%20that%20source%20data%20has%20no%20visible%20table%20(see%20picture%20capture%202b).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%20I%20am%20not%20using%20power%20query%2C%20because%20did%20not%20need%20before.%20I%20just%20installed%20now%20and%20it%20looks%2C%20that%20will%20work%2C%20hope.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20hint%20%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
jirikoci
New Contributor

Hi,

 

I am trying to create contingency table in excel from external access database. When I created first table, it is working but when I want to create second table, it tells me that in access database are no table for import.

Strange is, when I have in access database connected excel sheet I am able to create all tables, but when I have connected txt in access, so is posible to create only one contingency table.

 

Can you help?

2 Replies

Hello @jirikoci ,

 

Your question has not received any replies so far, so I'm trying to help you out. Your question is not very clear. You say you are "trying to create contingency table in excel from external access database". What does that mean? What steps are you taking? In Excel? In Access?

 

What is the "first table" and how did you create it? What is the "second table" and how did you created it?

 

I also don't understand your references to connect to txt in Access. Please provide more details. A few screenshots would help to illustrate what you are doing, and maybe you could put into words what you are trying to achieve.

 

Are you using Power Query to connect to Access? If not, why not? Power Query is the BEST way to connect to ANY data source from Excel.

Hi@Ingeborg Hawighorst,

 

at first I am beginner in Access I learning by myslef. I will try to explain better :).

I have Access database, where I have some tables whit basic data and linked excel file (see picture capture 1a), which is changing every day. Next I have created queries for future work.

When I want to create contingency tables in excel, is no problem to create 2 or more of them when linked file in access is excel (see picture capture 1b).

 

But, I need to link txt file to access database (see picture capture 2a), because it is original format of file. In access everything working like with linked excel file. The problem is when I want to create 2 or more contingency tables in excel. I am able to create first one and when I want to create second one, I received message that source data has no visible table (see picture capture 2b).

 

Otherwise I am not using power query, because did not need before. I just installed now and it looks, that will work, hope.

 

Thank you for hint :)

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies