I have problem with Excel file. In this video Excel file have vertical lines and all is properly divided with vertical lines... but when I download file vertical lines doesn't exist and I can't delete any part of document. What I should to do?
hi.. its a lovely video and i am learning a lot about access. midway at 06:43 in this video i am also getting a similar error message stating "Query input must contain at least one table or query" .. i followed your suggestions but the error message doesnt seem to go.. and i am stuck there.. i have tried to use a small data and the error message is still there.. i will be glad if you could give me some more suggestions... i already tried unchecking the box @04:02 .. the issue still exists.. ty
@djxcoo I would recommend that you play with your incoming data and try to narrow down where the problem is. Eliminate columns one at a time from your import and table analyzer wizard until it works. Then, when it does work, look at the column that you last eliminated, and ask yourself if there any special characters in the column name or data or anything that looks out of the ordinary. There might be something in your data or table structure that is breaking the wizard behind the scenes.
hello djdates i'm @6:43 of your video, I tried to follow the steps before that point. Unfortunately, I got a error message saying "Query input must contain at least one table or query" and then I cannot continue. What do you think am I missing here? need to learn this for my work. Thanks alot for the vids also
@TheMrScribbler Try unchecking the box @4:02 that says that the first row contains field names. Perhaps there is a weird character in one of your field names that is causing a problem.
@GogromaT Can you change the Control Display field to a Text Box? Changing this to Text Box is actually better, because just deleting the Row Source means that the field simply becomes a broken Lookup Field. Lookup fields are unique to Access, so my knowledge about them is pretty limited.
very well done sir keep it up it really helps me i love to see your videos and love to learn from it
Basheer8BCS 1 month ago
Hi we developed a software for this called "Excel To Access", "software-development.iga-t.com", regards, Max
TheMaxkuba 1 month ago
I have problem with Excel file. In this video Excel file have vertical lines and all is properly divided with vertical lines... but when I download file vertical lines doesn't exist and I can't delete any part of document. What I should to do?
blatribla 6 months ago
hi.. its a lovely video and i am learning a lot about access. midway at 06:43 in this video i am also getting a similar error message stating "Query input must contain at least one table or query" .. i followed your suggestions but the error message doesnt seem to go.. and i am stuck there.. i have tried to use a small data and the error message is still there.. i will be glad if you could give me some more suggestions... i already tried unchecking the box @04:02 .. the issue still exists.. ty
djxcoo 6 months ago
@djxcoo I would recommend that you play with your incoming data and try to narrow down where the problem is. Eliminate columns one at a time from your import and table analyzer wizard until it works. Then, when it does work, look at the column that you last eliminated, and ask yourself if there any special characters in the column name or data or anything that looks out of the ordinary. There might be something in your data or table structure that is breaking the wizard behind the scenes.
djdates 6 months ago
@djdates it now works. THANKS alot
TheMrScribbler 7 months ago
hello djdates i'm @6:43 of your video, I tried to follow the steps before that point. Unfortunately, I got a error message saying "Query input must contain at least one table or query" and then I cannot continue. What do you think am I missing here? need to learn this for my work. Thanks alot for the vids also
TheMrScribbler 7 months ago
@TheMrScribbler Try unchecking the box @4:02 that says that the first row contains field names. Perhaps there is a weird character in one of your field names that is causing a problem.
djdates 7 months ago
can't delete the raw source (lookup in access 2010)
GogromaT 1 year ago
@GogromaT Can you change the Control Display field to a Text Box? Changing this to Text Box is actually better, because just deleting the Row Source means that the field simply becomes a broken Lookup Field. Lookup fields are unique to Access, so my knowledge about them is pretty limited.
djdates 1 year ago
@djdates yes, now it works, thank you
GogromaT 1 year ago
i did have to change a regedit access entry to increase the 'file sharing lock count' but i did this and the table was analyzed as shown.
thetechnoPIMP 1 year ago
Interesting. Out of curiosity, what version of Windows are you on? What was the error message you got? Thanks.
djdates 1 year ago
Exellent ! Easy to follow.
sand2626 2 years ago