Preserving the order of Excel file without an ID field

[togo]

A CSV file has been converted into .XLS file using VBA code in Access and an Excel object.

Access imports the file. Excel has done nothing to it except change the format to XLS. So I'm ready to use VBA to start using the data, but the order of items in that file is critical, and when I do a query (openrecordset) Access will scramble the order of items... is there a way around that? The file comes in with many rows but just the one column.

[JoeM]

If you are importing the file into Access, let Access add an Autonumber Primary Key field. Then, if you use this field to sort by, it will keep the records in the same order as they were on the original file.

[togo]

haha. Solved the issue, wasnt hard at all

appExcel.Workbooks.Open strCSVPath, , , 2

2 specifies comma delimited, then save it

appExcel.ActiveWorkbook.SaveAs FileName:=Left(strXLSMPath, Len(strCSVPath) - 3) & "xlsm" _
, FileFormat:=52