Excel and data into access

[zrazzaq]

I have 700 forms in excel that were sent to me...I have to extract the data from these forms and place them into tables i created into access...Is there a way I can do this in vb without having to do this manually...
Please help
Thank you so much
Zishan

 

[Remou]

Have you looked at TransferSpreadsheet?

 

[zrazzaq]

well the spreadsheet is a form in excel can i do that

 

[Remou]

I am talking about DoCmd.TransferSpreadsheet. You will find it in Help for Access and VBA.

 

[snayjay]

Docmd.transferspreadsheet is only for transferring data from a spreadsheet to a table. Won't do anything for Forms. The short answer (to my knowledge) is no. You could open your spreadsheet and copy all then open a new form in design mode and paste all... but then you have name all objects and adjust form properties and such... very time consuming. Why would you have a need for 700 forms... maybe there is a better way of accomplishing the end result.

 

[easyit]

Isn't a form is representation of data in e sheet?

EasyIT

"Do you think that’s air you're breathing?