Import Forms from SQL Server

[LeonAtRC]

I have some Access forms in text format that were exported using "SaveAsText".

I want to put these into a sql table using a varchar(max) data field.

How do I load each text file, which has up to 1000 line of code, into a single record using the VARCHAR(MAX) field?

Can the text in the sql record be directly loaded using "LoadFromText" or will I have to rebuild the text file and load from that?

What I'm trying to do is remotly swap forms in an Access ADP file that is in use.

 

[kjv1611]

So you're saying you exported the actual records that are showing in these forms? If so, then you should be exporting the underlying recordsets rather than the forms, so that they'll be in a better format for transferring between data sources.

But it almost sounds like you're saying you exported the SQL code or underlying VBA code or something.. I'm not totally sure I follow what you're saying.

When I export a form as text, it just lists the records with some sort of text borders around the text to lay them out in similar fashion as in the form itself..

 

[lameid]

What I'm trying to do is remotly swap forms in an Access ADP file that is in use.

Your method is fundamentally flawed as kjv1611 points out that is the data and not object.

Any reason you are not just pushing out a whole new copy of the application?

Incremental object changes like these are typically handled by importing and exporting them to an Access file... If you want to use SQL, you would put that file in whatever the binary datatype is, and then read it out and process it on the other side. I've never stored any BLOB data in any database so I don't know the in's and out's although there is probably a FAQ about it (it may reference storing other files like pictures).