Basic question about table

[LonghornBob]

I have 3000 rows, 4 columns, in an Excel table.

I need that data in my Access table but it won't let me import, cut and paste, nothing.

I'm adding new rows but it's only letting me do them one at a time and I'm not doing that 2,500 times.

Any ideas?

Thanks in advance,

Wheeler

 

[PHV]

Have you header in the SpreadSheet ?
Have you tried the DoCmd.TransferSpreadsheet method ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TheAceMan1]

LonghornBob . . . .

If trouble presists, you could import to a new table. Then with an append query transfer the data.

See Ya! . . . . . .

 

[AndrewRW]

One thing I found out was that you need to make sure the column headers in the spreadsheet don't have a leading space in the names...you'll get an error message when you try to import the spreadsheet into Access.