Remove From My Forums

Where should I ask simple questions about Access database?

Question
0

Sign in to vote

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 articles

Wednesday, May 27, 2020 6:04 PM

Answers

1

Sign in to vote
For mysql migration you could also ask here for help.

https://forums.mysql.com/

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
0

Sign in to vote
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

0

Sign in to vote
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
0

Sign in to vote

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 articles

Wednesday, May 27, 2020 7:28 PM
0

Sign in to vote

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
0

Sign in to vote
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

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_win10-mso_2016/how-can-i-extract-information-for-each-table/d42942d4-0c35-4619-8182-1e7ef1e3c950?tm=1590682405478

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?

Thanks in advance.

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
1

Sign in to vote
For mysql migration you could also ask here for help.

https://forums.mysql.com/

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
0

Sign in to vote
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
0

Sign in to vote
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

Answered by:

Where should I ask simple questions about Access database?

Question

Answers

All replies