Getting Excel data into Access

[Pharcyde]

I have a table in Access(97) to which I have to import data from Excel(2002).

I've tried saving as .csv(comma delimiters), and also as .txt(tab delimiters) then copy&pasting. It works but misses out a couple of columns (maybe due to them being blank? Thought the commas would have sorted this!) so is no good.

I've also tried get external data in Access, but the wizard isnt installed at work...

I have until the end of today to get it done, or else its detention for me

Hope some of you folks can help me out here please

Much appreciated, Lee

 

[Ally]

In Excel, under the data menu there should be a Convert to MS Access option. If it's not there, you should be able to add-in by going to help and following the instructions there. If not, your techies should install at least one of the wizards for you otherwise you're not going to be able to finish the job.

 

[R6Flyer]

As long as your columns in Excel match up with the Access table (field names, formats, etc.) then you should be able to simply copy and paste append the data into the table.

Have you checked for any hidden columns in Excel as this could throw everything out.

Cheers

Flyer