Results 1 to 2 of 2
  1. #1
    Chappers is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    1

    Question Removing formulas from CSV file when importing data

    I am fairly new to Access having been tied up in Excel for so many years. I'm teaching myself as I go along so am reliant on great forums like this one and YouTube videos. I haven't managed to find anything yet that helps with my issue so am hoping there is someone reading this that knows a solution.



    My company's warehouse management system can export reports to CSV file that I have always imported into Excel without issue. The problem I am having putting them into Access is that all text fields contain a formula that tells Excel the value is text. Obviously Excel simply calculates the formula and displays the result plus if I really want to get rid of the formulas I can copy all and paste values.

    The problem is that Access imports them as text and therefore displays the formula with the text, (See picture of import wizard). I just want the text in brackets / parentheses to show and to strip out the =t("").

    Can anyone help with this?

    Click image for larger version. 

Name:	2016-04-29 09_01_31-Link Text Wizard.jpg 
Views:	6 
Size:	40.2 KB 
ID:	24497

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Cvs is text only.
    formulas only exist in Excel.
    if you want to keep the value of the formula, keep it in excel.
    if you want the formula, then you must recreate it in Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 12-03-2012, 05:03 PM
  2. importing data from an excel file
    By slimjen in forum Access
    Replies: 3
    Last Post: 09-21-2011, 12:38 PM
  3. Importing data from a .txt file
    By The Dad in forum Access
    Replies: 2
    Last Post: 08-25-2011, 01:45 PM
  4. Importing new data from same file once a week
    By fclanton in forum Import/Export Data
    Replies: 0
    Last Post: 11-11-2010, 09:22 AM
  5. importing data from csv file
    By sbglobal in forum Import/Export Data
    Replies: 2
    Last Post: 08-22-2010, 11:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums