Answered by:
Where should I ask simple questions about Access database?

Question
-
Hi,
I spent some time trying to find that forum but was unable so far.
My question is actually very simple, so if you know the answer to the question itself I'd appreciate the answer directly.
I have an Access database with many tables inside. I can open and view each individual table fine. I need to copy columns and being able to paste them into some other file (I need them in Word document). I cannot figure this simple task out. I highlight the columns, I press Copy, then I switch into different document (in my particular case I am first trying a new Visual Code file), press Paste and nothing happens.
How can I achieve such a simple task, please? I don't normally work with Access, thus it got me confused.
Thanks a lot in advance.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articlesWednesday, May 27, 2020 6:04 PM
Answers
-
For mysql migration you could also ask here for help.
https://forums.mysql.com/list.php?65
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
- Edited by Dave PatrickMVP Thursday, May 28, 2020 4:28 PM
- Proposed as answer by Guido Franzke Friday, June 5, 2020 5:59 AM
- Marked as answer by Guido Franzke Friday, June 5, 2020 5:59 AM
Thursday, May 28, 2020 4:26 PM -
I'd try asking for help over here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word
https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev
https://social.technet.microsoft.com/Forums/en-US/home?forum=word
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Guido Franzke Thursday, May 28, 2020 5:51 AM
- Marked as answer by Naomi N Thursday, May 28, 2020 6:25 PM
Wednesday, May 27, 2020 6:12 PM
All replies
-
I'd try asking for help over here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word
https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev
https://social.technet.microsoft.com/Forums/en-US/home?forum=word
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Guido Franzke Thursday, May 28, 2020 5:51 AM
- Marked as answer by Naomi N Thursday, May 28, 2020 6:25 PM
Wednesday, May 27, 2020 6:12 PM -
Thanks, in the meantime I believe I figured out a solution to my problem.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articlesWednesday, May 27, 2020 7:28 PM -
Sounds good, you're welcome.
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.Wednesday, May 27, 2020 7:41 PM -
The way I solved my first issue was to use the Export (I would need these tables in some format anyway, I suspect). However, I just asked this question
and hopefully I'll get an answer but if someone knows it and can respond, I'd appreciate it.
Eventually I need to update MySQL database with the information provided in that Access DB, so if someone can suggest the best and simplest approach for this task, I appreciate it too. My current idea is to extract data into csv file for each of the 10 tables within, then create tables in MySQL for each of these CSV files and then eventually update my main table in MySQL.
Do you know of a simpler process - say, somehow import the data from Access into MySQL without exporting into CSV first?
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles- Edited by Naomi N Thursday, May 28, 2020 4:23 PM
Thursday, May 28, 2020 4:21 PM -
For mysql migration you could also ask here for help.
https://forums.mysql.com/list.php?65
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
- Edited by Dave PatrickMVP Thursday, May 28, 2020 4:28 PM
- Proposed as answer by Guido Franzke Friday, June 5, 2020 5:59 AM
- Marked as answer by Guido Franzke Friday, June 5, 2020 5:59 AM
Thursday, May 28, 2020 4:26 PM -
Strange, I thought I replied, but my answer is not here either :(
I tried posting in the very top forum you pointed me in your first reply and I got some helpful answers (and then solved the problem myself), but once I marked the helpful answers as answers I was unable to continue my conversation with the 2 people who replied - this is quite inconvenient, IMHO - I don't know if this is by design or not.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles- Edited by Naomi N Thursday, May 28, 2020 6:28 PM
Thursday, May 28, 2020 6:27 PM -
The MySQL forums are too complex to use :(
First I needed to create an account which I did. Then in order to post you need to provide the SPAM prevention code which I did a few times but it still doesn't let me in.
All I wanted to post (for now), is that the very top sticky thread in that forum (the second sticky) has a post that results in 404 error.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles- Edited by Naomi N Thursday, May 28, 2020 7:03 PM
Thursday, May 28, 2020 7:01 PM