I have a rpt dump that one of my colleagues gave. I need to open this file as a SQL Table (I presume that this is possible since he generated the rpt dump from the SQL Table).
How do I do that. I am using SQL Server Management Studio. I can also open the rpt file as a separate file in SSMS.
Though this answer is late, I didn't see a canonical answer to the problem of opening the .rpt file format and writing it to a SQL table.
In SQL Server Management Studio in Object Explorer, right click on the database you want to load the file into and choose Tasks... Import Data.
Choose Flat File Source, select your file, then ensure the screen is setup to match the following screenshot (Code page=65001 UTF-8, Format=Ragged right, Column names in the first data row). Then click Next.
Click next and type in the name of your table in the format [dbo].[MyTable]
then click Edit Mappings and confirm the column data types match. String (DT_STR) columns should be varchar columns here. Unicode string (DT_WSTR) should be nvarchar columns here.
Click Next and Finish to run immediately. You should see success messages not errors hopefully:
select * from MyTable where MyColumn1 like '%(%'
may help you find that row. Please confirm that query returns only one row before you delete it.