How to upload a text file in Excel
@Texas and all the guys
I think my way is simplest, shorter and more precise.
1. Open Excel.
2. Import a NEW text file of the speedcams you want to handle and under ALL FILES.
3. Mark (while uploading) the "separators" you want and see how it will look to you in a reduced preview.
The full and exact way - [Only registered and activated users can see links. Click Here To Register...]
How to process a Text file in Excel and save it again as a Text file
Hi @Texas
As per your request, here is the way to import a Text file of spdcams into Excel and process it as you wish.
Quote:
1. Open Excel.
2. Import a NEW text file of the speedcams you want to handle.
3. Mark (while uploading) the "separators" you want and see how it will look in a reduced preview.
Open a new Excel sheet and then (follow the numbered steps):
1. Highlight DATA
2. Go To NEW QUERY
3. Point On From FILE
4. Choose Import Data From a Text File
5. IMPORT Text File
Sample view/total 218 spcams/file of: ISRAEL_31012024_ALLINONE_SPCDB
6. LOAD
7. ALL THE 218 SPDCAMS RECORDS WERE LOADED IN THE EXCEL
8. Finally - Save It As A Text File Type
After you have finished working on the Excel, save it first as an Excel file.
Then, go to FILE > SAVE AS and, in "save as type" - You can choose any of the three file type options highlighted in the image and, give this file a new name!
Go to the folder where the new .csv file was downloaded and change its extension from .csv to .txt!
Now, the new Text file is ready for you to work again in the navigation software.
germany speed file spc file
hello members,
i can not find a german speedcam file for 2023/4 maps.
is there one?