What is the fastest way?

[hgus393]

Hi all,

I have a massive excel sheet (350 000 rows 40 columns) that I am trying to get into Access. But before I write code for this, does anyone know which way is the fastest to get in data from Excel to Access? I have always defined excel as an object and from there got all the fields that I need. But I have a naging feeling that if I do this for the massive sheet Access will most certainly die.

Any inputs?

 

[vbaInet]

Access won't complain.

Use the Import Wizard.

 

[ghudson]

You can use the TransferSpreadsheet method if you want to automate the process.