Transfer Data from userform created in Excel to table Access 2003

[corrientedulce]

I have no Idea how to use access however I was told that it was the best
method to do what I am trying to accomplish.

I have a user form that I created in excel with VBA coding. From this form I
need to pull certain data and create a spreadsheet.

The final product needs to look something like this with the back slashes(/)
equals next column. The first column would be a hyperlink to the userform.

RRO#/DateRequest/Part#/PartName/Action/TargetDate/ActualDate/TargetDelt/Note
V3/1-11-2001/S2222-33-5/A/NotDrawnfromHyperlink/2-2-2002/3-3-2003/-5.00/
The data I need to pull from the excel userform is DateRequest, Part#,
PartName, and TargetDate.

I want to pull the data from the hyperlink document and place it in the
corresponding cells. I want the user to be able to add a hyperlink and the
data to automatically be filled in. I do not want to have to have the source
document open to view the data

The idea is that from the user form created I need to create a spreadsheet
that can gather certain information from several different user forms.


So now I want to use access to create the spreadsheets instead.

 

[scubadiver]

Access is not a spreadsheet so don't treat it like one. Be prepared for a
very steep learning curve, trust me!