Re: TransferSpreadSheet import excel to access problem (undesired reordering)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Enrique, please don't multipost. Your question has already been answered in
another newsgroup, so if one of the experts answered your same question in
one of the many places you posted this question, he'd be wasting his time.
For more information on posting questions in the newsgroups, please see the
following Web page:

http://www.mvps.org/access/netiquette.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"qq" <enrique.blanco@xxxxxxxxxxxxxx> wrote in message
news:1170715002.580318.326930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
I've got a problem importing a worksheet Excel into a temporary table
in
access. All the information is imported but the table is not ordered
as
it is originally in excel.

I'm using a VBA code rather simple as the following:

Private Sub Import()
..
Dim TableName As String
DoCmd.TransferSpreadsheet , , TableName, XLFileName, , test!"A10:AX"
...
End Sub

where XLFileName is my excel file and "test" my worksheet within that
file.


This code imported perfectly all the records from the excel file but
since the worksheet increased number of lines up to 1800 (which I do
not
consider is a big number!) all of them are imported but after the line
35 (not always the same) jumps to te line 1400 or so, then comes back
to
the line 36 until 80, then again another jump...
Despite of having all data the different order does not help
afterwards.

Do you have an idea about this strange re-ordering? Any help out
there?

Thanks beforehand
Qq



.

Relevant Pages

  • RE: Linked Excel file gives #Number! error in table
    ... when Linked to the xl worksheet, it does not occur if the xl worksheet is ... Link to the Excel file using DoCmd.TransferSpreadsheet. ... "It looks like Access cannot read that one particular cell". ... does the table get created during the import or are you importing to ...
    (microsoft.public.access.externaldata)
  • Re: transferSpreadSheet problem importing excel to access
    ... another newsgroup, so if one of the experts answered your same question ... I've got a problem importing a worksheet Excel into a temporary table in ... This code imported perfectly all the records from the excel file but since ...
    (microsoft.public.access.modulesdaovba)
  • TransferSpreadSheet import excel to access problem (undesired reordering)
    ... I've got a problem importing a worksheet Excel into a temporary table ... This code imported perfectly all the records from the excel file but ...
    (microsoft.public.access.externaldata)
  • transferSpreadSheet problem importing excel to access
    ... I've got a problem importing a worksheet Excel into a temporary table in ... is originally in excel. ... where XLFileName is my excel file and "test" my worksheet within that file. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Select Table dialog box after choosing data source
    ... > one worksheet in our Excel file. ... > the worksheet (with a dollar sign in front of it. ... connecting to an Excel data source. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)