export to a 2D array

[pradeep.sands]

Hi all,
I need some information/help regarding my project. Let me explain in brief what Im looking for.


Firstly, I have a Table

Now I have a form, from where I need to do the export. The export is to a ".C" file

For this I wrote something like this:

Dim text As Long
Dim path As String
path = Application.CurrentProject.path & "\export\"
Open (path & "\export.c") For Append As text
Print #text, ............
Close #text

So, using this I export the data into a txt file (replaced with an extension .C). It works.
Well, actually I need some help here regarding export. I need to export the data in the table as a 2D array into this C file.
For example, I wrote something like this:

  Print #text, "main ()" & vbCrLf _
                    ; "{ " & vbCrLf _
                    ; "int i = " & rs.Fields.Count & vbCrLf _
                    ; "int j = " & rs.RecordCount & vbCrLf _
                    ; "int Info[i][j]" & vbCrLf _
                      ....
                      ....

Now my Info[i][j] should contain all the data from the above table.
Ex.: considering abv table,
Info[2][4] = { (1,aaa,ccc,xyz) , (2,bbb,ddd,xyz) }

Can someone help me how do I realize this?

[TG_W]

Have you tried the "DoCmd.OutputTo" method?

Example with relevance to your needs (would need editing before your use) - DoCmd.OutputTo acOutputTable (or acOutputQuery), "Your Table or Query Name Here", acFormatTXT, "export.c"

[pradeep.sands]

Have you tried the "DoCmd.OutputTo" method?

Example with relevance to your needs (would need editing before your use) - DoCmd.OutputTo acOutputTable (or acOutputQuery), "Your Table or Query Name Here", acFormatTXT, "export.c"

Hi, Thanks for your reply. "DoCmd.OutputTo" would output the entire table structure and data to the text file, which is not what I want.
I want the following code to be in my output text file (.C file)

 
main()
int i=2;
int j=4;
int Info[2][4]={ (1,aaa,ccc,xyz) , (2,bbb,ddd,xyz) }

and this value of i,j are provided by the VBA using & rs.Fields.Count and & rs.RecordCount as shown in my first post and the int Info[2][4]={ (1,aaa,ccc,xyz) , (2,bbb,ddd,xyz) } should be provided by VBA by reading all records in table and then mapping to Info[i][j] but not directly hardcoding it

[TG_W]

I think I get what you are looking to do now. Unfortunately, that is beyond where I have gone in the VBA universe. You might consider posting this thread under the "Programming" section of the forums.

[pradeep.sands]

Ok. I will do that. Thank you.
And if anyone else can help me, please, waiting for your suggestions !!!