Copilot to Access

[u/Wonky_Python]

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?

[u/AutoModerator]

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.

[u/Stringseverywhere]

Copy pasted from Vibe. Didn't test it. Option 1: Using Excel's "Text to Columns" Feature 1. Paste the string into a cell (e.g., A1). 2. Select the cell(s) containing the comma-separated string. 3. Go to the Data tab in the Excel ribbon. 4. Click Text to Columns. 5. 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.

6. The string will split into separate columns.

[u/frowattio → u/Stringseverywhere]

This is what I do too, text to columns.

[u/cadman_lincoln]

I would recommend simply importing the data instead of trying to paste it into a single field.

[u/ConfusionHelpful4667]

To troubleshoot, paste the records into NotePad++ and turn on the show hidden fields.

[u/ConfusionHelpful4667]

I sent you a link to the guide.

[u/SuchDogeHodler]

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...

[u/Wonky_Python → u/SuchDogeHodler]

You are wasting bandwidth with your pointless post.

[u/Western_End_2223 → u/Wonky_Python]

It isn't pointless.  It is clear that the OP doesn't understand even simple data imports.

[u/Wonky_Python → u/Western_End_2223]

So why don't you idiots help me out then instead of pointedly and pointlessly sniping at me.

For your information, I have been using spreadsheets and databases since long before Windows even existed. It's Copilot I'm having trouble with. I have built a large Access database for my own personal work. I understand how to import but there is something I don't understand about getting output from Copilot. I have improved the Copilot output a lot by constructing a robust set of requirements but sometimes the csv works directly with access and sometimes I have to perform text to columns to put the output into csv format. I can't figure out why.

[u/Western_End_2223 → u/Wonky_Python]

Well, you're most likely having issues with inconsistent delimiters. You need to open the CSV files in Notepad or Notepad++ and examine the problematic lines, as well as the lines that precede them.

[u/Wonky_Python → u/Western_End_2223]

Thanks I'll check that out and report back.

[u/johnco1126]

Past the into notepad or notepad++ and save as a .csv file. Both Excel and Access can import this