Search results for query: *

never mind i figured it out, i just imported that field as text with Yes (duplicates ok) selected and it came in fine, thanks anyway everyone.

thanks, i figured it out, i imported that field as text with yes (duplicates ok) and it imports fine, thanks for the help.

oh and forgot to mention i'm pulling it into access to remove some duplicate data that is not needed so i can then export that substantially smaller file back to excel to do some data mining. and yes i have to export from our inhouse software with all the duplicates because its either all or...

okay i had a problem with importing a .txt file into excel as it was 150,000+ lines (this .txt file is exported from a in-house software that i'm using to export to excel and no there are no other ways to export) (oh also the file opens automatically in excel but cant load completely, the .txt...

okay i had a problem with importing a .txt file into excel as it was 150,000+ lines. i tried to import to Access but i get errors. i fixed most of them by bringing in most of the dates as "text" instead of Date/time as they would error that way. I am still having trouble with a date and time...

The inhouse software that i am using only has a button built in to export to excel, when the file is done processing (approx 20 mins) it then opens in excel as a .txt file. i don't open it it just opens by itself as part of the export process. then i just noticed that it is saved in my temp...

Ok heres my dilemma, I am running reports from a inhouse software that exports ONLY to excel. this leads to many problems as the reports are VERY large, 100,000 rows or more, they take about 20 mins to run and then they give the error of "file not loaded completely" they are exported as a .txt...