Equivolent SQL Server function for Access DoCmd.TransferText

15 pts.
Tags:
DoCmd.Transfer
Microsoft Access
SQL Server
Stored Procedures
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
ASKED: March 3, 2008  4:36 PM
UPDATED: March 5, 2008  7:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use the BULK IMPORT command to load a file into the SQL Server. BUL IMPORT probably won’t be able to do much with an HTML file. If you craft the BULK IMPORT parameters correctly you might be able to get it to work.

You might be better served to use DTS or SSIS to handle this import.

If you need to deal with exporting you will want to use DTS, SSIS or the BCP command line utility.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    65,460 pointsBadges:
    report
  • Paul48
    DoCmd.TransferText: (DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) is an Access method to import/export files to or from Access. In my case importing where TransferType is HTML, SpecificationName is a schema for the input file(not used), TableName is the table created, FileName is the input html file and HasFieldNames is a flag set to FALSE (no field names in the file. Thanks
    15 pointsBadges:
    report
  • Jerry Lees
    MrDenny is right, DTS or SSIS is teh best path, assuming it is a one time converstion.
    5,335 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following