how do I remove autoindexing for importing Spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have configured the Access Options\AutoIndex om Import/Create to blank i.e.
no text is entered.

i restarted Access but when I use TransferSpreadSheet to import a Sheet the
Table is sorted in some order.... Not sure what order. I just need to remove
it.....
 
You really don't need to do anything. The physical order of records in a
table is totally irrelevant. Use queries to provide the desired order or use
the Order By of the form, or use Sorting and Grouping for reports.
 
I think I need to make myself a bit clearer, I can only use the
TransferSpreadSheet method to import, when I open the Table that the sheet
has been imported to the Sort order is different to that of the Sheet. It
must equal that of the sheet so as to identify the Report headers of the
report. Can I force the Transferspreadsheet to import in the same order or
not.......
 
No

Now, this part:
It
must equal that of the sheet so as to identify the Report headers of the
report
Click to expand...
I do not understand. What has a report to do with the transferspreadsheet?
 
I have had a similar problem. We get a report from our credit card
company of all 20 or so Company credit cards broken down by cardholder,
and we needws to import it into Access. It begins life as a text file.

Long story short, after I imported the file into Excell, I created a
couple of formulas that identified the row they were on as garbage to be
ignored, line item data to be imported, or a report subheader which I
was using to to key the line items. (Card holder name was at the top,
and I had to tie it into the followign line items until the next card
holder.)
Then I import it into access, delete the garbage, and complete processing.

What I would suggest to you, is add a coloumn to the end of your data,
which consists of a sequential number, starting from 1. That will get
imported, and you can use that to sort the data after you load it up to
match the spreadsheet.

To more fully autromate the process, create another spreadsheet, link
the data on that to the first spreadsheet, put your Line Order Coloumn
there, and you are all set.

Hope this helps.

phl
 
Back
Top