Concatenation Problem

[Bob Rice]

Hi,

Am trying to update the recordset of a table that looks like a spreadsheet
(it is linked Excel).

I am trying to update the cells(fields) using an array. My code:

With A
For n = 1 to 5
.FindFirst "[Field" & n & "] = 1
.Edit
.[Field1] = Array(n)
.Update
Next

[Field1] above needs to increment to [Field2], [Field3], etc.

Any help is greatly appreciated.

 

[PC Datasheet]

Bob,

Take a look at the TransferSpreadsheet function. It will append data from a
table or query directly to the Excel worksheet you are linked to.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel