Import Excel into Access

[ewize1]

Hi there,

I have an Excel worksheet full of records, and I have an software written usign VB using Access database. However, the DB software was written without prior examination on the fields used in the Excel worksheet. Is it possible to import the information in Excel and use it for the DB software. Actually, the whole idea here is to minimise manual work to port Excel into Access.

Please help!!!

 

[Joe4]

Without knowing exactly what you are trying to do with these records (what does the VB do?), it is difficult to say what you can do to minimize work.

However to answer your questions, yes, you can import Excel information into Access. However, something that may be even easier yet is to Link the Excel file to the Access database (in the Table) section. No import is required then.

 

[ewize1]

Without knowing exactly what you are trying to do with these records (what does the VB do?), it is difficult to say what you can do to minimize work.

Though prior examination of the Excel file was not done, the software was written base on the user's requirements. It was done base on the actual forms they use, so, the fields used should be more or less the same. Their names may be different though. To minimise work, I suppose I can import (to save everything in Access) the records and rename the field names to the ones recognise by the software. Right?

 

[Joe4]

You could do that, however it may not be necessary. If you rename the fields in Excel to match what they are in Access, you could simply link your Excel table to Access.

It really shouldn't matter which of these methods you use. Sometimes, I find that importing Excel records into Access requires a little "fine tuning" or "finnagling", (more common if you are importing into pre-existing tables). Sometimes Access "rejects" certain records and then you have to figure out why. This is why I suggested linking to Access instead.

 

[ewize1]

Jmiskey, thank you for your valuable advice. I will try them out on my own to decide on the best method.