Access 2007 Tutorial 2.1. Importing Data
Loading...
Loading...
22,796
Loading...
There is no Interactive Transcript.
Link to this comment:
Share to:
Uploader Comments (djdates)
see all
All Comments (14)
-
very well done sir keep it up it really helps me i love to see your videos and love to learn from it
-
Hi we developed a software for this called "Excel To Access", "software-development.iga-t.co
m", regards, Max -
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?
-
@djdates it now works. THANKS alot
-
@djdates yes, now it works, thank you
Loading...
- 9:59
Access 2007 Tutorial 2.2. Queries and Group Byby djdates37,181 views
- 3:27
Access Tutorial 1by davidgkirk5,827 views
- 1:45
Access - Relationships Foreign Keysby HugoPhongPresents21,159 views
- 8:30
Access 2007 Tutorial 1.3. Many to Many Relationshipby djdates131,241 views
- 8:30
Access 2007 Tutorials For Free - Introduction Part 1by stuartrogermiles23,494 views
- 7:49
Importing Data into Access from Excelby DrJParrish5,673 views
- 10:00
Access 2007 Tutorial 3.1. Forms and Subformsby djdates103,213 views
- 4:42
Access 2007 Tutorial 5.3. Delete Duplicate Recordsby djdates19,361 views
- 17:00
Microsoft Access Tutorial for Beginners #1 - Overview (Access 2003)by MotionTraining67,877 views
- 3:29
Import CSV File into Accessby debissy1,912 views
- 8:41
How To Create Forms and Buttons in Accessby worktopjoint34,454 views
- 8:34
Excel 2007 Tutorial 4.1. Pie, Column & Line Chartsby djdates33,205 views
- 9:41
Access 2007 Basics Training Videoby videotrainingpro51,778 views
- 2:57
Access 2007 Tutorial: Overviewby gcflearnfree12,479 views
- 3:59
Excel - Auto MS Access Uploadby rstcomputer29,132 views
- 1:50
Access 2007 Tutorial Macro Actions Microsoft Training Lesson 17.2by teachucompinc20,371 views
- 1:42
Access 2007 relationshipsby namuoc167,044 views
- 1:36
Access 2007 Tutorial Creating New Databases Microsoft Training Lesson 2.1by teachucompinc31,042 views
- 10:06
Access 2007 Tutorial - Entering and Editing Databy gcflearnfree43,276 views
- 0:44
How to import data into Excel from an Access databaseby MHELP2U1,940 views
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
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