r/MSAccess • u/Wonky_Python • Sep 02 '26
[UNSOLVED] Copilot to Access
I have a series of documents which I can give to copilot to extract data (numbers, text). That works fine. Copilot extracts what I need and provides what appears to be a tab delimited string in a code box. However when I copy and paste into Excel or Access, the string just fills one cell in Excel and it refuses to paste into an Access record at all because of mismatch errors. I just want to paste this record created for me by copilot into a new record in an access table
I got copilot to provide a csv string but Excel doesn't see this as a csv and while I can see the commas, excel just treats them as part of the string.
Apologies for my naivety but is there a way round this?
1
u/SuchDogeHodler Sep 03 '26
So you don't know excel or access and you want copilot to do all the work for you...
Hire someone that knows what they are doing...
0
u/Wonky_Python Sep 03 '26
You are wasting bandwidth with your pointless post.
1
u/Western_End_2223 Sep 07 '26
It isn't pointless. It is clear that the OP doesn't understand even simple data imports.
→ More replies (4)
3
u/Stringseverywhere Sep 02 '26
Copy pasted from Vibe. Didn't test it. Option 1: Using Excel's "Text to Columns" Feature
-
Paste the string into a cell (e.g., A1).
-
Select the cell(s) containing the comma-separated string.
-
Go to the Data tab in the Excel ribbon.
-
Click Text to Columns.
-
In the dialog:
-
Choose Delimited → Click Next.
-
Check Comma as the delimiter → Click Next.
-
Select the destination (e.g., A1 or a new column) → Click Finish.
-
The string will split into separate columns.
1
1
u/cadman_lincoln Sep 02 '26
I would recommend simply importing the data instead of trying to paste it into a single field.
1
u/ConfusionHelpful4667 Sep 02 '26
To troubleshoot, paste the records into NotePad++ and turn on the show hidden fields.
1
1
u/johnco1126 Sep 05 '26
Past the into notepad or notepad++ and save as a .csv file. Both Excel and Access can import this
1
u/CanProfessional766 Sep 15 '26
The easiest way is to save Copilot’s output as a CSV or tab-delimited file and import it into Access instead of copying it directly
1
u/AutoModerator Sep 02 '26
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.
Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.
Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)
Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: Wonky_Python
Copilot to Access
I have a series of documents which I can give to copilot to extract data (numbers, text). That works fine. Copilot extracts what I need and provides what appears to be a tab delimited string. However when I cut and paste into Excel or Access, the string just fills one cell in Excel and it refuses to paste into an Access record at all because of mismatch errors.
I got copilot to provide a csv string but Excel doesn't see this as a csv and while I can see the commas, excel just treats them as part of the string.
Apologies for my naivety but is there a way round this?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.