-
1.) In an access database I know how to add a row, but how do you add a new column to a table in the database?
2.) I know a little about Scripting.FileSystemObject, but am just now using it for the first time. I know how to use createtextfile to write to a text file, and opentextfile to read to a text file...I was wondering if opentextfile can be used to write to the end of the file. Also if there is a way to remove a line from a file with out reading each line into an array then writting it again... any input about reading and writing a text file would be helpful.
:D Thank you for any help in advance,
-
i just have the answer for your first question;
for example
ALTER TABLE ANTIQUES ADD (PRICE DECIMAL(8,2) NULL);
good luck
