Re: transferSpreadSheet problem importing excel to access
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Feb 2007 16:14:32 -0800
Enrique, please don't multipost. Your question has already been answered in
another newsgroup, so if one of the experts answered your same question
here, 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.
"Quique" <quique@xxxxxxxxxx> wrote in message
news:eq8aqm$uus$1@xxxxxxxxxxxxxxxxxxx
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.
Any help out there?
Thanks beforehand
.
- References:
- Prev by Date: Re: Is an Array a solution here ?
- Next by Date: Re: Adding numeric data available in text field
- Previous by thread: transferSpreadSheet problem importing excel to access
- Index(es):
Relevant Pages
|
