Forum Discussion

arashd2105's avatar
arashd2105
Copper Contributor
Aug 02, 2020

trouble with imported value

Hello I am having trouble with the imported value on Access. My problem with imported value is that everytime I use imported data from a text file, the table ends up looking uneven. I will show a picture to clarify. jason kspencer john 

access
  • jason's avatar
    jason
    Copper Contributor
    Aug 02, 2020

    arashd2105   Hard to say for sure without looking at the source data.  But most common issue with text file import is delimiters.  If its a CSV - there maybe commas in your data for example.

    Make sure your source data has values in each column.  Test by owning in Excel, which will do a similar import.

  • Daniel_Pineault's avatar
    Daniel_Pineault
    MVP
    Aug 02, 2020
    What does uneven mean? What are you expecting?

    Your image is very poor and we can zoom in to make anything out to understand the issue. Try take a screenshot using the snipping tool perhaps.

Resources