Importing from Excel

[WaltLukeIII]

I am trying to import from an excel spreadsheet and I keep just getting a single empty field with a label of F1. I am using the following code<br><br>DoCmd.TransferSpreadsheet acImport, 6, _ &quot;Practice&quot;, path, True, &quot;A1:E320&quot;<br><br>where path is the name of the file<br>and practice is the name of the new table

 

[Guest_imported]

Just a guess but 6 is for excel 4 I bet you have a higher version then that<br>try 8<br>6&nbsp;&nbsp;acSpreadsheetTypeExcel4<br>5&nbsp;&nbsp;acSpreadsheetTypeExcel5<br>5&nbsp;&nbsp;acSpreadsheetTypeExcel7<br>8&nbsp;&nbsp;acSpreadsheetTypeExcel97<br>

 

[WaltLukeIII]

it gives me an erro that I used an argument that doesn't evaluate to a valid numeric value when I use the number 8 but thanks for the suggestion

 

[Guest_imported]

are you using excel 97 or an older version ?<br><br>see famousb FAQ if you haven't already.<br><A HREF="

http://www.tek-tips.com/gfaq.cfm/lev2/4/lev3/27/spid/181#29"

TARGET="_new">

http://www.tek-tips.com/gfaq.cfm/lev2/4/lev3/27/spid/181#29</A>

 

[WaltLukeIII]

i don't know what I did but I have gotten it to work using 6 the data that I was getting, I am not sure what it was written on and it was only letting me use read only So I copyed the data and made a new sheet and it works. Thanks for the help though<br><br>Walt III