Linking to a CSV file Access Trims char's from some records

M

Michael

I have a table created by a link to a .csv file. Some of the records have the first Character trimmed off

I can open the .csv file in excel and then save and close the .csv and Access picks the char's back up

Here is the entire process

file.txt is created from a unix job stream
file.txt is linked to an access table
tbl1 is queried
qry1 is exported to an .xls file
xls file is data mapped to a .csv file
..csv file is linked to an access table

I know this sound like a mess but it allows us to touch the data from multiple sources. I am going to search for any special characters that I can't see with notepad.(maybe a suggestion on a good windows based text editor would help

I think I might just write a script to open the .csv file and save it with excel and just move on, but I would like to know what is causing this oddity

Thank

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Cannot import CSV file into ACCESS 1
CSV files and having numbers and strings in there... 9
|9 can't find the field '|' Error when importing a csv to Access 2 1
linked csv file not all rows 4
Invalid Argument Error when importing .csv to Linked Table 1
linked csv shows not all rows 0
VBSript to read multiple CSV files & write out to 1 CSV file 10

Top