copy data from excel to access db?

[thepunisher]

How do i copy the data from excel spreadsheet to an access db, using vba?

 

[lupins46]

1. Are you doing this in Access or Excel?

2. Have you looked at just using the XL worksheet as a linked table in Access?

 

[BNPMike]

Go into Help. It's quicker than posting here.

Or... create a Macro (transferSpreadsheet) and save it as VBA, then look at the code.

 

[thepunisher]

Im doing it in Excel, so the linked table in Access probly wont work.

transferSpreadsheet was one possibility i tried
, but it didnt seem to do anything for me.

But im resigned to inserting them using an excel query executed from excel.

 

[BNPMike]

Maybe it would be better to do it from Access.

 

[thepunisher]

I cant, i need to keep it in excel for the user, i wish it was in acccess though!

It needs to be sent from excel to access because of the number of records. It is near 120000 or more. They all have to be clumped together so the user can see records for an entire year.

 

[PHV]

the number of records. It is near 120000 or more
Which version of Excel are you using ?
AFAIK, more than 65536 rows is a big problem for any version of version of Excel.

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

 

[thepunisher]

Excel 2002.

Chief Dan George-Get ready little lady, hell is coming to breakfast

 

[PHV]

Ask the Excel help engine for limitations.
Max sheet size: 65536 rows x 255 columns.

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